Oracle PL/SQL Language Pocket Reference

01.10.2007

Englisch

9780596514044

O'Reilly and Associates

Nein

Steven Feuerstein, Bill Pribyl, Chip Dawes

178

4

Unbekannter Einband

syntax, Oracle PL/SQL, language, Oracle language reference, Oracle programming

Inhaltsverzeichnis 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 Statements Loops Simple Loop Numeric FOR Loop Cursor FOR Loop WHILE Loop REPEAT UNTIL Loop Emulation EXIT Statement CONTINUE Statement (Oracle Database 11g) Loop Labels Database Interaction Sequences in PLSQL Transaction Management Autonomous Transactions Cursors in PL/SQL Explicit Cursors Implicit Cursors Dynamic Cursors 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 Fields of Records Assigning Records Records and DML Nested 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 Built-in Packages 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 Triggers DDL 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 Calling Packaged Functions in SQL Column/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 Compiler Performing Native Compilation of PL/SQL Java Language Integration Example Publishing Java to PL/SQL Data Dictionary Index