Oracle 9i added SQL 1999 support, which includes OUTER JOIN.
In SQL 92 syntax the where clause can have both the join
relationships and filter conditions. In SQL 1999 syntax
the where clause only contains filter conditions.
Note: Oracle 9i allows both SQL92 and SQL 1999 syntax to
peacefully
D'oh!
Shoulda thought of that. It's standard
procedures on upgrades.
Thanks Mladen.
On Friday 04 July 2003 11:29, Mladen Gogala wrote:
Parameter to disable database triggers is:
_system_trig_enabled = FALSE
This is 9i parameter. Alternatively, if you start the database up in the
Thursday, July 3, 2003, 5:40:37 AM, you wrote:
bnini SQL*Loader reads a set of records from a file, generates INSERT
bnini commands,
This is the key right here. A conventional path load
generates INSERT statements. A direct path load does not. A
direct-path load passes preformatted blocks to the
Dear Gaja,
With your many splendid deeds in the name of performance management (my personal
favorite being the fantastic "Compulsive Tuning Disorder" diagnosis) it's
only fair that your name will - until something better comes along - be synonymous
(spelling?) with the best RAID-technology