Oracle Database 11g R2

Oracle Database 11g R2

New & Advanced Features for Developers

eBook - 2011
Rate this:
The purpose of this Oracle 11g course is to present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle 11g R1 or R2 release or have been substantially improved in these new versions. Such advanced features include online application redefinition using Editions, employing the full range of index types to achieve maximum performance, and advanced SQL query techniques. Among the specific subjects presented in this course are: Perform online redefinition of database-resident applications using Edition-based Redefinition; Permit immediate application upgrade of live applications and online users by means of cross-edition triggers; Creating and using directory objects within the database; A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic, bitmap and bitmap join indexes; A comprehensive look at all table types available when building an application schema, including heap-organized tables, index clusters, hash clusters, index-organized tables, external tables, temporary tables, read-only and compressed tables; Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures; Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions; How to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions; Enhancements to the PL/SQL programming language and coding capabilities; New and advanced SQL language application development capabilities
Publisher: [Boston] : Sideris Courseware Corporation, c2011 (Norwood, Mass. : [generator])
ISBN: 9781936930036


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.

Age Suitability

Add Age Suitability

There are no age suitabilities for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further

Subject Headings


Find it at VPL

To Top