Home
Search results “Oracle alter session processes” for the 2014
ORACLE - Alter Table
 
17:43
Views: 145 Cihan Özhan
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7412 BhagyaRaj Katta
SCOTT schema in Oracle
 
04:29
plz subscribe blog :http://javaweb4u.blogspot.in/ When you started installing oracle ,it asked for global database name and database passwordthat password is used for the sys system sysman account. SQL : conn user/password; SQL : conn scott/tiger; Error message is displayed: the account is locked. 1. Try to login as "system" - pass SQL : conn system/password; SQL : @%ORACLE_HOME%\RDBMS\ADMIN\SCOTT.sql 2. Unlock "scott" SQL : alter user scott account unlock; 3. Can change "tiger": SQL : alter user scott identified by tiger; 4. SQL : conn scott/tiger; -Success scott account is locked in 11g due to security thinking, Now you can type Connection Name :ORCL ,username:Scott,password:tiger to login
Views: 12472 Javaweb4u
ODI 12C Flat File to Table mapping
 
11:47
Oracle Data Integrator 12 Project Flat File to Table mapping.
Views: 11940 Praveen Kumar
Introducing TMS NOW
 
02:44
http://www.capgemini.com/tmsnow Built on the latest release of Oracle Transportation Management (OTM) by Capgemini, a Diamond-level partner of Oracle, TMS NOW offers a streamlined and flexible way to implement a Transportation Management System (TMS) which saves companies time and money. In TMS NOW the logistics processes and technical workflows which support order consolidation, planning, tendering, track and trace, freight settlement and reporting for shippers are pre-built, to help you obtain value from your TMS as quickly as possible. The solution can be delivered on premise, or in SaaS mode with a subscription-based commercial model, and can evolve to meet your company's changing needs and scale.
Views: 17620 Capgemini
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 189353 Manish Sharma
Oracle Alt Sorgular
 
29:52
Views: 753 Cihan Özhan
3  alter table
 
08:00
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 417 etldeveloper
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 27858 Jeff Smith
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/ Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 41393 Manish Sharma
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 170953 BBarters
ODI 12C Slowly Changing Dimension Type II Mapping
 
14:10
Oracle Data Integrator 12C Slowly Changing Dimension Type II Mapping
Views: 7731 Praveen Kumar
Changing Oracle BPM Human Task Parameters
 
12:35
This is an extract from lesson 2 in AVIO's self-paced on-demand Oracle BPM Developer Workshop (A-211v), and it describes how to change human task parameters after the human task has already been created. It also shows the trick on how to update the ADF Data Control for the human task.
Views: 2957 Dan Atwood
Importing Visio Processes into Oracle BPM 12c
 
07:13
This shows how to import Visio processes into Oracle BPM 12c.
Views: 1747 Dan Atwood
Sysdba privilege in Oracle   | Operating System Authentication in Oracle | Oracle  DBA Videos
 
51:13
This video is the part of "Oracle Database Administration Made Simple" Series. This video discuss about the following -- Discussion on database authentication -- Discussion on OS ( operating System) authentication -- Sysdba privilege
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 14124 OracleDBVision
Oracle BPM 12c - Quick Start Installation
 
16:40
This video demonstrates the new Oracle BPM Quick Start Installer - beginning with the installation of JDeveloper 12.1.3, starting the embedded Weblogic server, deploying a simple BPM process and testing it via Enterprise Manager.
Views: 7671 Danilo Schmiedel
OBIEE Dynamic Session Variables - Creating and Using in an Analysis - OBIEE Online Training
 
12:33
This video tutorial demonstrates how to create an OBIEE database-driven session variable using the BI Admin Tool. The initialization block selects data from a database table to set the value of the variable. After creating the session variable and init block, we can then use the variable in an analysis filter, and well as display the value in the title view.- https://www.fireboxtraining.com/obiee-training
Views: 32055 Firebox Training
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 99695 Manish Sharma
Oracle Data Integrator Interface Example 1
 
59:03
Oracle Data Integrator Interface example for oracle to oracle table and Flow Control and static Control ODI Tutorial for Beginners. Oracle Data Integrator Tutorial ODI 11g Tutorial ODI 12c Tutorial
Views: 29438 TechLake
Netra 240 replace defected CPU procedure
 
05:12
How to replace a defected CPU on Sun Netra 240 Server
Views: 2484 Aref Kmail
SQL tutorial 21: How To Rename Table in SQL using ALTER TABLE statement By Manish Sharma
 
04:19
Oracle Database 11g Tutorial 21 : How to rename table using SQL Alter Table Links Website Article of in-depth Knowledge http://www.rebellionrider.com/alter-table/rename-table-using-alter-table.htm Create table using comand prompt and SQL Developer Tutorial 14 http://youtu.be/UU0EEfpa-2c Create table using EM tutorial 15 http://youtu.be/I-LUXP9GmPU Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 40958 Manish Sharma
ODI 12C Table to Flat File Mapping
 
06:48
Oracle Data Integrator 12 Project Table to Flat File mapping.
Views: 8525 Praveen Kumar
How to design and build Menu in Oracle Form Builder
 
20:08
How to design and build Menu in Oracle Forms. Designing and building menu in Oracle Form and attaching in forms in design time. This is an Online Training oracle tutorial video to make viewer to be able to build menu in a simple manner.
Views: 27642 Subhroneel Ganguly
Topology Dataserver, Physical and Logical Schema creation in ODI
 
30:46
Creating ODI Topology objects like Data Servers Creation, Physical Schema Creation, Context Creation and logical schema creation and assigning contexts and physical schema. ODI Tutorial for Beginners. Oracle Data Integrator Tutorial ODI 11g Tutorial ODI 12c Tutorial
Views: 15769 TechLake
Partition and Partition point parallel data processing and data redistribution
 
08:36
This video demonstrates, 1) What is partition and partition point. 2) How are they used together to sever the purpose of parallel processing of data, ensuring the data integrity. 3) How it helps in obtaining better performance.
Views: 26516 Informatica Support
How to read and interpret an explain plan by Daniel Morgan (English)
 
01:08:05
Webinar done in 2010 by Oracle ACE Director Daniel Morgan regarding how to read and interpret an Oracle explain plan
Views: 15965 OracleMania
Oracle BPM Workspace - Searching For Work Items
 
04:29
This shows you how to search for work items in Oracle BPM's Workspace. It includes a discussion on how flex fields can be used to facilitate this as well as an undocumented trick to search from information carried in the process payload.
Views: 245 Dan Atwood
SQL Tutorial 2: Create Database
 
13:06
The video presents on how to create database in IBM DB2 Express-C Server. The SQL commands used here are not limited to DB2. A specific set of SQL commands are standardized to able also server machines can communicate to each other no matter it is in DB2, Oracle, SQL Server, Informix, MySQL, and other relational database management systems (RDBMS). It starts with the definition of a database and what particular objects you can place inside it. These include schema, sequence, table, views, stored procedure, user-defined functions (UDF) that are mostly present inside a database system. How do you connect or use a database is included in the video. It explains what is a schema and the default schema is used by DB2. You can create your own schema and include inside your database. Set the schema first to avoid repeating or including it as you type you SQL scripts. The same is true when you are working with views, stored procedures, and user defined functions (UDF). It explains also on how to create a table inside a database. Set the primary keys and data types of columns. Primary key set uniqueness of a row instance. This is somehow limits any duplicate entry of a particular code, data in one column or set of columns (composite key). The video cites an example to check how a primary key works. This tutorial shows the use of INSERT INTO command. This is how to insert or place record/row in a table. You may insert one set of row or multiple of rows in one INSERT INTO command.
Views: 18457 Jerry Esperanza
Building a stored procedure (3:59)
 
04:00
In this tutorial, you'll learn the process of building a stored procedure -- from creating, running, deploying and debugging it, using IBM Data Studio.
Views: 5396 IBM Redbooks
Self Service Procurement | Changing a Requisition
 
00:57
This video tutorial applies to Rel 9 through Rel 12. It shows you how to make changes to a requisition.
Process Monitor: Processes, Threads and Thread Stacks
 
09:57
LoveMyTool.com blog video the shows how to explore processes and thread operation with procmon.
Views: 6602 Paul Offord
How to Install a Performance Exhaust System
 
05:34
Deep tone and more Horsepower. Realtruck offers a wide variety of Performance exhaust http://www.realtruck.com/exhausts/ from mild to extreme. With an exhaust system you are allowing your vehicles full potential to be released allowing for more horsepower and greater torque. We carry a broad selection from the top brands on the market today, including Flowmaster, Gibson, Magnaflow, Heartthrob, MBRP, and CGS Motorsports. Installed on a 2014 GMC Sierra Denali 1500 5.3 liter. Check out our Promotions and Deals: http://www.realtruck.com/lets-talk-trucks/ Subscribe to our Channel: http://www.youtube.com/user/RealTruckCom Follow us on Facebook: http://www.realtruck.com/facebook/?ut... Follow us on Twitter: http://www.realtruck.com/twitter/?utm... Follow us on Google+: http://www.realtruck.com/gplus/?utm_c... FREE SHIPPING Give us a call at 866-262-3738 Video Transcription: Hi guys, John here with RealTruck.com. We've been getting a lot of questions lately about how to measure your exhaust to make sure you get the right exhaust tip. Well, I'm going to show you just exactly how to do that. Now, on this particular truck, it's a little bit different of a scenario for measuring. If you have a pipe on your truck that's cut straight off, it makes it way easier. On this one, and I'll show you here real quick where you can get messed up - on this pipe, if you measure outside to outside because of the sliced off angle, it's going to show us three and a half inches. That's not accurate. If this pipe were straight, no problem. But what we're going to do is we're just going to hold our tape measure up here, kind of give it an eyeball look. And that tells me that this is a three inch pipe. So, that's what we're going to get for our exhaust pipe for this truck, we'll get a three inch tip. Like I said, if it's cut straight off, just measure outside to outside. If it's cut off at an angle like this, you're going to have to do the eyeball thing. So, it's not too tough of a process, pretty simple, and there you have it.
Views: 37299 RealTruck.com
Part 19   Copying data from one table to another table using SqlBulkCopy
 
09:35
In this video we will discuss copying data from one table to another table. The source and destination tables may be in the same database or in different databases and these database can be on the same sql server or in different servers. In Part 18 we discussed, loading xml data into sql server table using sqlbulkcopy. We will be continuing with the example we worked with in Part 18. Step 1 : Create a new database. Name it SourceDB. Execute the following sql script to create Departments and Employees tables, and to populate with data. Create table Departments ( ID int primary key identity, Name nvarchar(50), Location nvarchar(50) ) GO Create table Employees ( ID int primary key identity, Name nvarchar(50), Gender nvarchar(50), DepartmentId int foreign key references Departments(Id) ) GO Insert into Departments values ('IT', 'New York') Insert into Departments values ('HR', 'London') Insert into Departments values ('Payroll', 'Muumbai') GO Insert into Employees values ('Mark', 'Male', 1) Insert into Employees values ('John', 'Male', 1) Insert into Employees values ('Mary', 'Female', 2) Insert into Employees values ('Steve', 'Male', 2) Insert into Employees values ('Ben', 'Male', 3) GO Step 2 : Create another new database. Name it DestinationDB. Execute the sql script to just create Departments and Employees tables. Here we have just the structre of the tables and no data. We will be moving data from SourceDB tables to DestinationDB tables. Step 3 : Include the following 2 connection strings for the Source and Destination databases in the web.config file of the Demo project we created in Part 18. [connectionStrings] [add name="SourceCS" connectionString="server=.;database=SourceDB;Integrated Security=True" providerName="System.Data.SqlClient" /] [add name="DestinationCS" connectionString="server=.;database=DestinationDB;Integrated Security=True" providerName="System.Data.SqlClient" /] [/connectionStrings] Step 4 : Copy and paste the following code in the button click event handler method in the code-behind file string sourceCS = ConfigurationManager.ConnectionStrings["SourceCS"].ConnectionString; string destinationCS = ConfigurationManager.ConnectionStrings["DestinationCS"].ConnectionString; using (SqlConnection sourceCon = new SqlConnection(sourceCS)) { SqlCommand cmd = new SqlCommand("Select * from Departments", sourceCon); sourceCon.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { using (SqlConnection destinationCon = new SqlConnection(destinationCS)) { using (SqlBulkCopy bc = new SqlBulkCopy(destinationCon)) { bc.DestinationTableName = "Departments"; destinationCon.Open(); bc.WriteToServer(rdr); } } } cmd = new SqlCommand("Select * from Employees", sourceCon); using (SqlDataReader rdr = cmd.ExecuteReader()) { using (SqlConnection destinationCon = new SqlConnection(destinationCS)) { using (SqlBulkCopy bc = new SqlBulkCopy(destinationCon)) { bc.DestinationTableName = "Employees"; destinationCon.Open(); bc.WriteToServer(rdr); } } } } Note: Please make sure to include the following using declarations using System; using System.Configuration; using System.Data; using System.Data.SqlClient; As the column names in the source and destination tables are the same column mappings are not required. Text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-19-copying-data-from-one-table-to.html Slides http://csharp-video-tutorials.blogspot.com/2014/09/part-19-copying-data-from-one-table-to_24.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 60484 kudvenkat
SQL Server Temp Table Persistence - STORED PROCEDURES
 
05:11
Discussion of Temporary Tables, Persistence and STORED PROCEDURES. Temp Tables are created in the tempdb system database in SQL Server. They are persistent but not necessarily long lived, particularly when executing a store procedure that has its own unique connection to SQL Server. Temp tables are created with strange looking table names that are actually unique instances of the hash mark named table that are related via the specific connection to SQL Server, whether it be through a query window or a stored procedure.
Views: 988 Dave Merton
Userenv function in oracle
 
04:02
This session tells you what is userenv function in oracle and how to use it.
Views: 190 kiran sethy
SQL tutorial 32: How To Insert Data into a Table Using SQL Developer
 
05:16
SQL Tutorial 32 How To Insert Data into a Table Using SQL Developer and How to delete Data/Row From a table. Website : http://www.RebellionRider.com New Series of #SQL tutorial on How to Insert Data. I'll cover all the traditional way along with some tips and tricks on Data insertion. Keep watching and enjoy #SQLing Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from www.RebellionRider.com
Views: 53808 Manish Sharma
Examples on Oracle Database Auditing |  Oracle Database Security | auditing in oracle 11g
 
21:15
This is the part of the series "Oracle DBA Videos" on Oracle Database Security. The following topics are covered in practical -- General idea about database auditing -- Statement level auditing -- Privilege level auditing -- Object level auditing
Views: 13348 Wysheid Wysheid
PL SQL Preferences - Fonts
 
01:58
Adjusting PL/SQL Developer Preferences to speed up or enhance your work. I find the default font of Courier is harder to read so I changed it to Source Code Pro. Visual Studio uses Consolas.
Views: 3906 Kevin Stokes
Oracle Data Guard Tutorial - Open the Standby Read Only (Part 2 of 4)
 
16:49
This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences. Opening the standby database read-only. This has in fact been possible since the automation of redo transport and redo apply when it was first introduced in release 8i. Redo is received on the standby database but is not applied. So the redo is written to the RFS, slave to standby logs, archive to standby logs into archive logs but there's no apply done. So recoverability is not compromised. There's still no danger being lots of data. You're still receiving. The thing is open read-only. What does that mean? It means you can run queries against it. You can offload all your heavyweight queries from the primary to the standby. When I say all of them, even queries that require vast massive temporary space, those horrendous queries, those doing hash joins between multi gigabyte tables, they'll be generating many gigabytes of temporary data. You can write temporary data. Provided that you're using proper temporary tablespaces which you're certain you should be, you can run any query no matter how big, no matter how much temporary data it needs. You can also write audit data and this is important because with version 11, there's quite a lot of auditing enabled by default. By default, that auditing goes to the database, writing database tables. And you can't write to a database table in a read-only database. That we can configure for automatic switching and direct the audit records to the operating system or the trail instead. The queries you run, why is this such a good facility? First, you're taking stress off the primary. I'm sure that we're all DBAs here and we all know how difficult it is to tune your database or a concurrent workload that includes both high volume DML and includes heavyweight queries. Basically, you can't tune that way at all. Offloading the queries to the physical standby will reduce a lot of stress from the primary. So your DML should run significantly better and you can even do a certain amount of tuning on the standby to tune for optimal query performance. The most obvious tuning one would do, would be the memory parameters. No one could for example give the primary a massive PGA aggregate target and the much smaller SGA target or use indeed automatic memory management, perhaps cell tuning. One can adjust many parameters to do with tuning the optimizer to drive the optimizer to a certain execution plan, to exploit the environments. All that can be done on an open read-only database. How does one do it? It really couldn't be simpler. If we look at my physical standby here, this thing database role, physical standby - and if we select the open mode from v$ database, we find this in mount mode. How do we actually open at read-only? First off, we have to stop the recovery process because remember redo is received but no applied. You have to cancel the recovery. So "alter database recover managed standby database cancel." That will give us a read consistent version of the database. The command is intelligent enough to know that there might be incomplete transactions. Long-run transactions could've been partially received. We will end up with a read consistent version. To cancel it, all we do is alter database open read-only. It is that simple.
Views: 3164 SkillBuilders
Informatica -- FTP File using Command Task
 
16:34
Using FTP Command and Informatica command task, we will FTP file from Windows Server to process it using Informatica at Linux Machine
Views: 22799 Mandar Gogate
Fast Data In Action: OLL Live (Recorded Webcast Event)
 
41:37
A demonstration of how Fusion Middleware can be used to build an architecture based on Oracle Event Processor, Coherence and Oracle Database for customers that have a requirement for a mixture of real-time processing, near-time analysis and long running batch analysis of the same or a similar data set. This use-case is certainly common in Financial Services where our customers need to process market and financial data in real-time as well as analyse long-term trends in large data sets. This architecture will also be applicable to any industry where the customer has requirements for analysing data at different frequencies and volumes. For example: • Financial Services -- Real-time Market and Financial data • Commercial Banking -- Customer Experience • Retail -- Real-time point of sale analysis • Telecommunications -- Real-time billing analysis • Oil and Gas -- Drilling (upstream) analysis • Energy -- Smart metering • Logistics -- Vehicle location analysis Presented by Simon Cook: Simon has 17 years experience working with Java and Middleware technolgies. He worked for 14 years at Sun Microsystems specialising in Java Enterprise Middleware and related technolgies. Since Oracle acquired Sun Microsystems 3 years ago, Simon has worked at a Senior Principal Sales Consultant for Oracle's Fusion Middleware product suite. Focusing on the Cloud Application Foundation products and supporting Oracle's sales teams in the Financial Services sector. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle BPM Online Training SM Consultants
 
46:52
Visit : http://smconsultant.com/online-training-calendar/ to know more. S&M Consultants are the best online training provider for Oracle ADF SOABPEL WebCenter Database AIA WebLogic OAF APEX Java and other Oracle technologies.
General Session at 14th Cloud Expo | Marty Gubar, Director of Product Management at Oracle
 
35:10
Understanding the future of Big Data is crucial in the early stages of decision making around Big Data architectures. In the enterprise, what stands out is the need to integrate Hadoop smoothly into your existing data warehouse architecture, while taking advantage of existing skills and investments. In his General Session at 14th Cloud Expo® (http://www.CloudComputingExpo.com/), Marty Gubar, Director of Product Management at Oracle, will present a strategy for enabling integrated data management using both Hadoop and relational technologies. In particular, he'll look at how SQL, long the standard for the data warehouse, is increasingly being used on Hadoop. The real prize, though, is Smart SQL processing, seamlessly integrating the data warehouse and Hadoop into a single, Big Data Management System. Follow Cloud Expo on Twitter: @CloudExpo
Views: 108 Cloud Expo TV
Oracle SQL Joining Tables Theory   Part 1
 
11:41
Oracle Tutorials
Views: 267 Rohullah Jan
1Z0-879 - Oracle Solaris10 Test System Exam Upgrade Questions
 
01:14
For Oracle 1Z0-879 Test Questions and Answers Please Visit: https://www.PassEasily.com/1Z0-879.htm Exam Section 1 – Install Software Questions (Test Coverage 15%) Exam Section 2 – Manage Test File Systems Questions (Test Coverage 25%) Exam Section 3 – Perform System Boot and Shutdown Procedures for SPARC, x64, and x86-based systems Questions (Test Coverage 13%) Exam Section 4 – Perform User and Security Administration Questions (Test Coverage 23%) Exam Section 5 – Perform System Test Backups and Restores Questions (Test Coverage 24%) (Exam Time) : 70 minutes (Number of Test Questions): 66 (1Z0-879 Passing Score): 54% 1. Install Software •Test the Solaris 10 OS installation and upgrade options for CD / DVD, including how to provide Minimal Installations for SPARC exam, x64, and x86-based systems. •Perform an OS installation from CD / DVD for SPARC, x64, and x86- based questions systems. 2. Manage File Systems •Explain disk architecture including the UFS exam file system capabilities and naming conventions for devices for SPARC, x64, and x86-based systems. •Use the prtconf and format commands to list devices, explain critical issues of the /etc/path_to_inst file and reconfigure devices by performing a reconfiguration boot or using the devfsadm command for SPARC, x64, and x86-based questions systems. •Given a test scenario, partition a disk correctly using the appropriate files, commands, and options, and manage disk labels using SMI and EFI labels as they relate to disk sets. •Explain the Solaris 10 exam OS file system, including disk-based, distributed, devfs, and memory file systems related to SMF, and create a new UFS file system using options for 1Tbyte and 1Tbyte file systems. •Perform Solaris test 10 OS package administration using command-line interface commands and manage software patches for the Solaris OS, including preparing for patch administration, and installing and removing patches using the patchadd and patchrm questions commands. 3. Perform System Boot and Shutdown Procedures for SPARC, x64, and x86-based systems •Given a test scenario, explain the BIOS settings for booting, abort sequence, and displaying POST, including BIOS configuration for x64 and x86-based system. •Perform system boot and shutdown procedures, including identifying the system's boot device, creating and removing custom device aliases, viewing and changing NVRAM parameters questions, and interrupting an unresponsive system. •Explain the Exam Service Management Facility and the phases of the boot process. •Use SMF or legacy commands and scripts to control both the boot and shutdown procedures. •Describe the purpose, functions and features of the GRand Unified Questions Bootloader (GRUB), including how to modify x86 system boot behavior, manage GRUB boot archives, boot a system exam in the GRUB-based boot environment and interrupt an unresponsive system. 4. Perform User and Security Administration •Test monitor system access by using appropriate commands. •Perform system security by switching users on a questions system, and by becoming root and monitoring. •Control system security through restricting ftp access and using /etc/hosts.equiv and $HOME/ .rhosts files, and Exam SSH fundamentals. •Restrict access to data in files through the use of group membership, ownership, and special file questions. 5. Perform System Backups and Restores •Backup a mounted file system by creating a UFS exam snapshot and performing a backup of the snapshot file. •Test data from a UFS snapshot and delete the UFS snapshot.
Views: 107 Pass Oracle Easily
Oracle - R12 - Purchasing Period and Inventory Accounting Period
 
04:06
Open Oracle application Purchasing Period and Inventory Accounting Period
1Z0-522 - JD Edwards Test EnterpriseOne Financial Management Exam Questions
 
01:10
For Oracle 1Z0-522 Test Questions and Answers Please Visit: https://www.PassEasily.com/1Z0-522.htm Exam Section 1 – Common Foundation / Address Book Questions (Test Coverage 15%) Exam Section 2 – Accounts Payable Questions (Test Coverage 15%) Exam Section 3 – General Test Accounting Questions (Test Coverage 30%) Exam Section 4 – Accounts Receivable Questions (Test Coverage 15%) Exam Section 5 – Fixed Assets Questions (Test Coverage 25%) (Exam Time): 105 minutes (Number of Test Questions): 73 (1Z0-522 Passing Score): 68% 1. Common Foundation / Address Book • Work with UDCs • Manage Interactive Test Versions • Work with Environments • Using the Visual Assist • Password exam management • Working with the Grid • Exporting Grid Data • Using the Data Browser to search for questions data • Working with Submitted Jobs • Describe the Address Book • Navigation using Fast Path • Using Fast Keys • Autopopulating Information • Work with Processing Options • Use Address Book Questions Category Codes • Interpret Date Warnings and Errors • Configure Next Numbers 2. Accounts Payable • Describe the AP Business Process Test Overview • Set up Components for Accounts Payable • Implement AAIs for Accounts Payable • Set up Suppliers • Perform the Procure to Pay Questions Process • Match Vouchers • Process Vouchers • Post 1Z0-522 AP Transactions to the GL • Set up Automatic Payment Exam Processing • Create Automatic Payments • Process Manual Payments • Approve and Post Payments to the General Test Ledger • Update and Review Tax Information • Process 1099 Year End • Review Accounts Payable Reports • Review Accounts Payable Integrity Reports • Troubleshoot Automatic Payments • Troubleshoot Accounts Payable Vouchers • Work with Accounts Payable Drafts 3. General Accounting • Describe 1Z0-522 GL Business Process Overview • Set up and configure GL • Set up General Accounting AAIs • Set up 1Z0-522 Up DMAAIs • Work with Category Questions Codes • Set up Intercompany Settlements • Revise the Exam Organization • Process Journal Entries • Set up Allocations • Use 1Z0-522 Account Reconciliation • Update and Review Tax Information • Review General Accounting Reports and Inquires • Review General Accounting Test Integrity Reports • Review Financial Exam Reports • Set up Test Multicurrency • Process Online Consolidations • Work with Budgets • Troubleshoot General Questions Ledger • Forecasting 1Z0-522 Cash
Views: 1630 Easily Test Oracle
The ABCs of Clinical Trial Management Systems
 
01:00:01
Learn the fundamentals of clinical trial management systems (CTMS). -- Gone are the days of using spreadsheets to manage clinical trials. Fortunately, a clinical trial management system (CTMS) such as Oracle Siebel CTMS, offers an effective method for streamlining business processes, reducing cost and saving time. Whether you are a sponsor running global trials or a research organization conducting hundreds of studies, we invite you to listen to Perficient’s Param Singh, Director of Clinical Trial Management Solutions, cover the following topics in this webinar: -- What is a CTMS and who needs one -- Key functions of a CTMS -- CTMS selection process -- System types and implementation options -- Best practices Stay on top of Life Sciences technologies by following us here: Twitter: http://www.twitter.com/Perficient_LS Facebook: http://www.facebook.com/Perficient LinkedIn: http://www.linkedin.com/company/165444 Google+: https://plus.google.com/+Perficient SlideShare: http://www.slideshare.net/PerficientInc
Views: 6744 Perficient, Inc.