Wronski Associates
Twitter
LinkedIn
Login
Contact Us
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Close
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Login
Contact Us
Twitter
LinkedIn
Send to a Friend
Content to send
Oracle 11g Differences for Developers
Course Number:
583-JK
Recommended Duration:
1-2 days
Intended Audience:
Experienced application developers and designers who will be using Oracle11g.
Course Overview
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 11g and its features. Course is normally 2 days with labs, 1 day without. Course optionally covers major Oracle9i and/or Oracle9i features.
Objectives
Participants will be introduced to the new and improved features of Oracle 11g that concern Application Developers. Several exercises involve practice using new items discussed in the class.
Prerequisites
Experienced Oracle application developers and designers who will be using Oracle11g.
Topics
Oracle 11 overview
iSqlPlus and SQLPLUSW gone
Virtual Columns
Uses for Virtual Columns
XML Binary XMLTYPE
Next-Generation LOB Securefile
SQL Pivot and Unpivot
New Function REGEXP_COUNT
New Functions: CUBE_TABLE, XMLCAST, XMLEXISTS, XMLDIFF, XMLPATCH
PL/SQL compiler enhancements
PL/SQL enhancements
Sequence numbers in PL/SQL
PL/SQL CONTINUE
PL/SQL Trigger improvements
CALL syntax has improved
Simple_integer
Simple_float
Simple_double
New JDBC driver support Java 5 (1.5) & 6
Pro* and OCI improvements
Share with others
Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message
Can't Read?
Click to Generate New Code
Enter the verification code shown above into the text box below