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 coexis
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 ava