Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.

Oracle Corporations version 10 of its flagship RDBMS product. Questions with this tag should include the full database version if possible ( If version 10.2 is being referenced, then the oracle-10g-r2 tag should be used.

Code Language (used for syntax highlighting): lang-sql