Oracle® PL–SQL™ by Example – Benjamin Rosenzweig, Elena S. Rakhimov – 4th Edition

Description

Oracle 11g has introduced a number of new features and improvements for PL/SQL. This introduction briefly describes features not covered in this book and points you to specific chapters
for features that are within scope of this book. The list of features described here is also available in the “What’s New in PL/SQL?” section of the PL/SQL Language manual offered as
part of Oracle help available online.
The new PL/SQL features and enhancements are as follows:
. Enhancements to regular expression built-in SQL
. SIMPLE_INTEGER; SIMPLE_FLOAT; and SIMPLE_DOUBLE datatypes
. CONTINUE statement
. in PL/SQL expressions
. Dynamic SQL enhancements
. Named and mixed notation in PL/SQL subprogram invocations
. Cross-session PL/SQL function result cache
. More control over triggers
. Compound triggers
. resident connection pool
. Automatic subprogram inlining
. PL/Scope
. PL/SQL hierarchical profiler
. PL/SQL native compiler generates native code directly

View more
  • Acknowledgments
    About the Authors
    Introduction
    C. 1 PL/SQL Concepts
    C. 2 General Programming Language Fundamentals
    C. 3 SQL in PL/SQL
    C. 4 Conditional Control: IF Statements
    C. 5 Conditional Control: CASE Statements
    C. 6 Iterative Control: Part I
    C. 7 Iterative Control: Part II
    C. 8 Error Handling and Built-in Exceptions
    C. 9 Exceptions
    C. 10 Exceptions: Advanced Concepts
    C. 11 Introduction to Cursors
    C. 12 Advanced Cursors
    C. 13 Triggers
    C. 14 Compound Triggers
    C. 15 Collections
    C. 16 Records
    C. 17 Native Dynamic SQL
    C. 18 Bulk SQL
    C. 19 Procedures
    C. 20 Functions
    C. 21 Packages
    C. 22 Stored Code
    C. 23 Object Types in Oracle
    C. 24 Oracle Supplied Packages
    A. A PL/SQL Formatting Guide
    A. B Student Database Schema
    A. C ANSI SQL Standards
    A. D Answers to the Try It Yourself Sections
    INDEX
  • Citation

Download now Oracle® PL–SQL™ by Example

Type of file
Language
Download RAR
Download PDF
Pages
File size
Book
English
--
--
--

Leave us a comment

No Comments

guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x