Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageOracle 9i New Features - SQL
Description:
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Familiarity with Oracle 8i SQL and an understanding of relational database design concepts.
New Join Syntax:
CROSS Joins
NATURAL Joins
INNER Joins
OUTER Joins
NATURAL Joins
INNER Joins
OUTER Joins
Embedding SQL Changes in Other Languages :
Other New SQL Features:
CASE expressions
NULLIF
COALESCE
Scalar subqueries
MERGE
Analytical functions
FOR UPDATE WAIT
USING clause
ON clause
Grouping sets
NULLIF
COALESCE
Scalar subqueries
MERGE
Analytical functions
FOR UPDATE WAIT
USING clause
ON clause
Grouping sets
New Date-based Datatypes:
Timestanp
Interval
Functions Using Date-based Datatypes
Interval
Functions Using Date-based Datatypes
Enhancements to LOBs and PL/SQL:
PL/SQL Native Compilation: