Oracle PL/SQL language: pocket reference

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling <li.

"A guide to Oracle PL/SQL language fundamentals"--Cover.

"Covers Oracle database 11g" --Cover.

Includes index.

Previous ed.: 2004.

Oracle PL/SQL Language Pocket Reference, 4th Edition; Conventions; PL/SQL Language Fundamentals; Identifiers; Boolean, Numeric, and String Literals; Numeric Literals; Datetime Interval Literals; Delimiters; Comments; Pragmas; Statements; Block Structure; Variables and Program Data; Character datatypes; Unicode character datatypes; Datetime datatypes; BOOLEAN datatype; LOB Datatypes; Implicit Datatype Conversions; NULLs in PL/SQL; Declaring Variables; Constants; Default values; Anchored Declarations; Programmer-Defined Subtypes; Conditional and Sequential Control; IF-THEN-ELSE combination

IF-THEN-ELSIF combinationCASE statement; CASE expression; Sequential Control Statements; NULL; Loops; Numeric FOR Loop; Cursor FOR Loop; WHILE Loop; REPEAT UNTIL Loop Emulation; EXIT Statement; CONTINUE Statement (Oracle Database 11g); Loop Labels; Database Interaction; Transaction Management; ROLLBACK; SAVEPOINT; SET TRANSACTION; LOCK TABLE; Autonomous Transactions; Cursors in PL/SQL; Opening explicit cursors; Fetching from explicit cursors; Closing explicit cursors; Explicit cursor attributes; Implicit Cursors; WHERE CURRENT OF clause; Dynamic Cursors; DBMS_SQL

SQL Injection and Bind Variables…