1.
unloading data using external tables in 10g
I am assuming that readers are familiar with external table concepts and DIRECTORY objects. SQL> CREATE DIRECTORY xt_dir AS 'c:\temp\ora'; Directory created ...
2.
the merge statement in oracle 9i
Oracle treats MERGE as a MERGE and not an UPDATE+INSERT statement. ... We can compare the overall performance of MERGE against a pre-9i SQL solution. ...
3.
case expressions and statements in oracle 9i
Oracle has provided a built-in exception for this event; CASE_NOT_FOUND. The following example shows what happens if the CASE statement cannot find a true ...
4.
user-defined aggregate functions in oracle 9i
With the development framework for data cartridges mapped out for us by Oracle, user-defined aggregate functions are actually very simple to create. ...
5.
associative arrays in oracle 9i release 2
Somewhere around Oracle 8, PL/SQL Tables were re-badged as "index-by tables", which referred to the syntax we used to declare the array types with (TYPE ...
6.
external tables in oracle 9i
external tables in oracle 9i. External tables enable us to read ... In the EMP_XT table, we have a DATE column that needs to be converted as on line 26, ...
7.
oracle-developer.net
Jan 28, 2009 ... Articles and utilities for Oracle developers. ... oracle-developer.net is a resource for Oracle database developers. ...
8.
dml error logging in oracle 10g release 2
Line 3: the LOG ERRORS clause is how we invoke DML error logging. We are telling Oracle that we wish our DML statement to succeed in the event that we ...
9.
the merge statement in oracle 9i
the merge statement in oracle 9i. This article introduces the new MERGE SQL command (sometimes referred to as "UPSERT"). MERGE is a DML command that enables ...
10.
the merge statement in oracle 9i
We can now see an example of the MERGE statement. In the following example, ... Oracle treats MERGE as a MERGE and not an UPDATE+INSERT statement. ...
