| Description |
1 online resource (xxxiii, 1154 pages) : illustrations |
| Contents |
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 |
|
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 |
|
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 |
|
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 |
| Summary |
"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 to develop applications. With full coverage of the latest features and tools, this Oracle Press guide provides examples of web applications in native PL/SQL, JSP, and PHP. The book explains how to access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy security. A Netflix case study example is used throughout the book as the basis for all coding examples. This enables application design consideration, data types, structures, and coding approaches to build an integrated view of the PL/SQL programming language. The examples collectively provide you with both a reference to how various programming concepts work and how components fit together to solve real-world problems"-- Provided by publisher |
|
"Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide"-- Provided by publisher |
| Notes |
Includes index |
|
Print version record |
| SUBJECT |
Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760
|
|
Oracle (Computer file) fast |
| Subject |
PL/SQL (Computer program language)
|
|
Database design.
|
|
Database management.
|
|
Debugging in computer science.
|
|
COMPUTERS -- Database Management -- General.
|
|
Database design
|
|
Database management
|
|
Debugging in computer science
|
|
PL/SQL (Computer program language)
|
| Form |
Electronic book
|
| ISBN |
9780071812443 |
|
007181244X |
|
