Oracle PL/SQL language : pocket reference / Steven Feuerstein, Bill Pribyl, and Chip Dawes.

Format:

Book

Author/Creator:

Feuerstein, Steven, author.

Pribyl, Bill, author.

Dawes, Chip, author.

Language:

English

Subjects (All):

Oracle (Computer file).

PL/SQL (Computer program language).

Relational databases.

Physical Description:

1 online resource (189 p.)

Edition:

5th ed.

Other Title:

Oracle processing language/structured query language

Place of Publication:

Sebastopol, CA : O'Reilly, 2015.

System Details:

text file

Summary:

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12 c . Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of: Fundamental language elements, such as block structure, datatypes, and declarations Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Execution of PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming .

Contents:

Copyright; Table of Contents; Oracle PL/SQL Language Pocket Reference; Introduction; Acknowledgments; Conventions; PL/SQL Language Fundamentals; PL/SQL Character Set; Identifiers; Boolean, Numeric, and String Literals; Numeric Literals; Datetime Interval Literals; Delimiters; Comments; Pragmas; Statements; Block Structure; Variables and Program Data; Scalar Datatypes; LOB Datatypes; Implicit Datatype Conversions; NULLs in PL/SQL; Declaring Variables; Anchored Declarations; Programmer-Defined Subtypes; Conditional and Sequential Control; Conditional Control Statements

Sequential Control StatementsLoops; Simple Loop; Numeric FOR Loop; Cursor FOR Loop; WHILE Loop; "Repeat Until" Loop Emulation; EXIT Statement; CONTINUE Statement; Loop Labels; Database Interaction; Sequences in PL/SQL; Transaction Management; Autonomous Transactions; Cursors in PL/SQL; Explicit Cursors; Implicit Cursors; Native Dynamic SQL; DBMS_SQL; SQL Injection and Bind Variables; Cursor Variables; Cursor Expressions; Exception Handling; Declaring Exceptions; Raising Exceptions; Scope; Propagation; Records in PL/SQL; Declaring Records; Referencing a Record's Fields; Assigning Records

Records and DMLNested Records; Collections in PL/SQL; Declaring a Collection; Initializing a Collection; Adding and Removing Elements; Nested Table Functions; Collection Methods; Collections and Privileges; Nested Collections; Bulk Binds; Built-in Functions and Packages; Built-in Functions; Built-in Regular Expression Functions; Stored Procedures and Functions; Procedures; Functions; Parameters; Local Programs; Program Overloading; Forward Declarations; Table Functions; Function Result Cache; Privileges and Stored PL/SQL; Triggers; Creating Triggers; Trigger Predicates; DML Events

Compound DML TriggersDDL Events; Database Events; Packages; Package Structure; Referencing Package Elements; Package Data; SERIALLY_REUSABLE Pragma; Package Initialization; Calling PL/SQL Functions in SQL; Calling a Function; Improving Performance of Calling PL/SQL Functions from SQL; Column Name Versus Function Name Precedence; Object-Oriented Features; Object Types; Type Inheritance; Methods; Methods in Subtypes; Manipulating Objects in PL/SQL and SQL; Upcasting and Downcasting; Changing Object Types; Compilation; Compiling Stored PL/SQL Programs; Conditional Compilation; Compiler Warnings

Optimizing CompilerPerforming Native Compilation of PL/SQL; Java Language Integration; Example; Publishing Java to PL/SQL; Data Dictionary; Index

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed January 20, 2016).

ISBN:

9781491919996

149191999X

9781491919989

1491919981

OCLC:

921930837