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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: McLaughlin, Michael (Michael J.)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, ©2014.
Temas:
Oracle (Computer file)
PL/SQL (Computer program language)
Database design.
Database management.
Debugging in computer science.
PL/SQL (Langage de programmation)
Bases de données > Conception.
Bases de données > Gestion.
Débogage.
COMPUTERS > Database Management > General.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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

Ejemplares similares