By browsing this site, you agree to the use of cookies, which enhance your experience, analyze how you integrate with our site and customize our content to your personal needs and search. Saiba mais
0
Español
Português
Select country:
Antigua & Barbuda
Argentina
Bahamas
Barbados
Belize
Bolivia
Brazil
Chile
Colombia
Costa Rica
Cuba
Dominica
Dominican Republic
Ecuador
El Salvador
Grenada
Guatemala
Guyana
Honduras
Jamaica
Mexico
Nicaragua
Panama
Paraguay
Peru
Puerto Rico
Saint Kitts & Nevis
Saint Lucia
Saint Vincent & Grenadines
Suriname
Trinidad & Tobago
Uruguay
Venezuela
Albania
Austria
Belgium
Bosnia & Herzegovina
Bulgaria
Croatia
Cyprus
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Hungary
Iceland
Ireland
Italy
Latvia
Lithuania
Luxembourg
Malta
Montenegro
Netherlands
North Macedonia
Norway
Poland
Portugal
Romania
Serbia
Slovakia
Slovenia
Spain
Sweden
Switzerland
Turkey
Ukraine
United Kingdom
Canada
United States
Australia
Cambodia
China
Hong Kong
India
Indonesia
Japan
Malaysia
Micronesia
New Zealand
Pakistan
Philippines
Singapore
South Korea
Taiwan
Thailand
Vietnam
Bahrain
Iran
Iraq
Israel
Jordan
Kuwait
Lebanon
Oman
Qatar
Saudi Arabia
Syria
United Arab Emirates
Algeria
Egypt
Kenya
Morocco
Nigeria
Senegal
South Africa
Sudan
Tunisia
We are happy to advise you!
Contact
Oracle Database 11g: Program Development (Self-Study Course)
Course Objectives
Describe the SQL and PL/SQL performance improvements. List the SQL and PL/SQL language functionality enhancements Use the SQL and PL/SQL language usability enhancements Describe the PHP enhancements Understand the API and precompiler enhancements List Rules Manager Enhancements Use Rule Conditions for Text Events
Product Description
Performance Improvements for PL/SQL
Intra-Unit Inlining Inlining: Example Compound Trigger: Overview Compound Trigger: Example Other Trigger Changes Creating a Disabled Trigger FOLLOWS Clause Language Functionality Enhancements for PL/SQL
Regular Expression Enhancements REGEXP_INSTR: Examples REGEXP_SUBSTR: Example PL/SQL Finer-Grained Dependency Management: Example Support for Generalized Invocation Setting the DDL_LOCK_TIMEOUT Parameter Dynamic SQL: Functional Completeness Transforming a DBMS_SQL Cursor into a REF CURSOR Language Usability Enhancements for PL/SQL
Sequence Enhancement Using Sequences in PL/SQL Expressions PL/SQL CONTINUE Statement Named and Mixed Notation from SQL Read-Only Tables API and Precompiler Enhancements
Client-Side Query Cache Pro*C/C++ and Pro*Cobol Precompiler Enhancements IBM DB2 Array INSERT and SELECT Syntax Support IBM DB2 Array SELECT: Example Converting Precompiler Batch Inserts Pro*Cobol Endianness Support Oracle JVM JIT Compiler Enhanced DBMS_JAVA Package Oracle Database Resident Connection Pooling
Database Resident Connection Pooling Enabling DRCP in your Application Starting and Stopping DRCP Monitoring Performance Tuning DRCP Using Database Resident Connection Pooling Rules Manager New Features
Overview of Rules Manager Enhancements Rule Conditions for Text Events Support for Shareable Primitive Rule Conditions Support For Disabling And Enabling Rules Support for Purging Events in Development Environments Support for Collection Events and Aggregate Predicates Support for Text Predicates in Stored Expressions