Oracle Database 12c PL/SQL programming
"A complete update of the essential desktop reference for PL/SQL, rewritten and expanded by to highlight the massive changes in Oracle Database 12c. Written by an Oracle ACE, Oracle Database 12c PL/SQL Programming offers in-depth information on the entire PL/SQL language and its extensibility t...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
New York
McGraw-Hill Education
2014
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Implicit REF CURSOR Parameter Binding
- Supporting Scripts
- Summary
- Mastery Check
- Chapter 3: PL/SQL Basics
- Block Structure
- Execution Block
- Basic Block Structure
- Declaration Block
- Exception Block
- Behavior of Variables in Blocks
- Anonymous Blocks
- Nested Anonymous Blocks
- Local Named Blocks
- Stored Named Blocks
- Basic Scalar and Composite Data Types
- Scalar Data Types
- Strings
- Dates
- Numbers
- Attribute and Table Anchoring
- Composite Data Types
- SQL UDT
- PL/SQL Record Type
- SQL Collection
- PL/SQL Collection
- Control Structures
- Conditional Structures
- If, Elsif, and Else Statements
- CASE Statement
- Iterative Structures
- For Loop Statements
- While Loop Statements
- Simple Loop Statements
- Exceptions
- User-Defined Exceptions
- Dynamic User-Defined Exceptions
- Bulk Operations
- Functions, Procedures, and Packages
- Functions
- Procedures
- Packages
- Transaction Scope
- Single Transaction Scope
- Multiple Transaction Scopes
- Database Triggers
- Summary
- Mastery Check
- Chapter 4: Language Fundamentals
- Lexical Units
- Delimiters
- Identifiers
- Reserved Words and Keywords
- The PL/SQL Language
- The Oracle Processing Architecture
- Two-Tier Model
- N-Tier Model
- Summary
- Mastery Check
- Chapter 2: New Features
- New SQL Features
- Data Catalog DIRECTORY Qualifies a LIBRARY Object
- Define Tables with Valid-Time (VT) Support
- Table with Explicit VT Columns
- Table with Implicit VT Columns
- Enhanced Oracle Native LEFT OUTER JOIN Syntax
- Default Values for Columns Based on Sequences
- Default Values for Explicit Null Insertion
- Identity Columns
- Increased Size Limits of String and Raw Types
- Pass Results from SQL Statements to External Programs
- Cover
- Title Page
- Copyright Page
- About the Author
- About the Contributing Author
- About the Technical Editor
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- Book Outline
- Part I: PL/SQL Fundamentals
- Part II: PL/SQL Programming
- Part III: Appendixes and Glossary
- Lexicon
- SQL Lexicon
- PL/SQL Stored Programs
- Other Conventions
- Data Model and Source Code to Download
- Part I: Oracle PL/SQL
- Chapter 1: Oracle PL/SQL Development Overview
- PL/SQL's History and Background
- Oracle Development Architecture
- The Database
- Native SQL Support for Query Row Limits and Offsets
- Oracle Database Driver for MySQL Applications
- SQL CROSS APPLY, OUTER APPLY, and LATERAL
- Bequeath CURRENT_USER Views
- New PL/SQL Features
- Caching of Invoker Rights Functions
- Ability to White List PL/SQL Program Unit Callers
- Native Client API Support for PL/SQL Types
- New PL/SQL Package UTL_CALL_STACK
- DBMS_UTILITY Adds EXPAND_SQL_TEXT Subprogram
- DBMS_SQL Adds a New Formal Schema to the PARSE Procedure
- PL/SQL Functions in SQL WITH Clause
- PL/SQL-Specific Data Types Allowed in SQL