Content Inside:
New Features in PL/SQL for Oracle Database 10g, PL/SQL performance is improved across the board. Most improvements are
automatic, with no action required from you. Global optimization of PL/SQL code is controlled by the PLSQL_OPTIMIZE_LEVEL initialization parameter. The default optimization level improves performance for a broad range of PL/SQL operations. Most users should never need to change the default optimization level. Overview of PL/SQL, Understanding the Main Features of PL/SQL, Advantages of PL/SQL,Processing Queries with PL/SQL, Fundamentals of the PL/SQL Language, Tight Integration with SQL, PL/SQL Architecture In the Oracle Database Server and in Oracle tools, PL/SQL Naming Conventions, Scope and Visibility of PL/SQL Identifiers, PL/SQL Datatypes, PL/SQL Character and String Types, PL/SQL National Character Types, Overview of PL/SQL Subtypes, Using PL/SQL Control Structures, Using PL/SQL Collections and Records, Performing SQL Operations from PL/SQL, Performing SQL Operations with Native Dynamic SQL, Using PL/SQL Subprograms, Handling PL/SQL Errors, Tuning PL/SQL Applications for Performance, Guidelines for Avoiding PL/SQL Performance Problems, Avoiding Memory Overhead in PL/SQL Code, Profiling and Tracing PL/SQL Programs, Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT), Retrieving Query Results into Collections with the BULK COLLECT Clause, Sample PL/SQL Programs. This complete reference guide is available to download in pdf format consist of 492 pages.
this book available to download at http://oracle-docs.dartmouth.edu/, we found it via google pdf search
Tags : sql performance problems, oracle database server, native dynamic sql, sql datatypes, oracle docs, complete reference guide, optimization level, sql operations, global optimization, google, sql programs, oracle 10g, naming conventions, oracle tools, sql fundamentals
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.