This course is designed for developers, systems analysts, database administrators & technical support professionals who are experienced with SQL.

Duration: 2 Days

Using Set Operators
Describing the Set Operators
UNION
UNION ALL
INTERSECT
MINUS
Using ROLLUP as an Extension to the Group by Clause
Using CUBE as an Extension to the Group by Clause
Using the WITH Clause
Writing a Multicolumn Subquery
Writing a Subquery in a FROM Clause
Correlated Subqueries
Hierarchical Retrieval
The Benefits of the Hierarchical Query
Ordering the Rows Retrieved by a Hierarchical Query
Formatting Hierarchical Data
Excluding Branches from the Tree Structure
Multitable Inserts
INSERT ALL Syntax
INSERT FIRST Syntax
The MERGE Statement
Flashback Query
Flashback Query Requirements
Using Statement Level Flashback Query
Using Session Level Flashback Query
Writing SQL to Generate SQL

Before attending this course, students must have an understanding of Oracle8i or Oracle9i Database Administration, experience in Oracle tuning, backup and recovery, & networking, & SQL & PL/SQL programming experience is also required.

This course is designed for Oracle8i or Oracle9i Database Administrators who want a comprehensive overview of the New Features of Oracle10g.