Curriculum
- 1 Section
- 9 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Topics9
- 1.1Selection & Setup Of The Database Interface Considering Available Tools Selecting The Appropriate Tool Oracle NET Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*PLUS Setup JDeveloper
- 1.2About BIND & SUBSTITUTION Variables Using SQL Developer Using SQL*PLUS
- 1.3Choosing A Database Programming Language What Is Database Programming? PL/SQL Performance Advantages Integration With Other Languages
- 1.4PL/SQL Language Fundamentals PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Database Output SQL*PLUS Input Of A Program Block
- 1.5DECLARE Section About The DECLARE Section DECLARE Primitive Types Declaration Options NOT NULL CONSTANT Data Dictionary Integration %TYPE Declare Simple User-Defined Types TYPE … TABLE TYPE … RECORD Extended User-Defined Types
- 1.6BEGIN Section About The BEGIN Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE
- 1.7Exception Section About The EXCEPTION Section Isolating The Specific EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE & SQLERRM Example SQL%ROWCOUNT & SELECT…INTO
- 1.8Beyond The Basics: Explicit Cursors About Explicit Cursors Extended Cursor Techniques FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR…LOOP Cursors
- 1.9Beyond The Basics: Nested Blocks Beyond The Basics: DECLARED Subprograms Using DECLARED Subprograms DECLARED Procedure DECLARED Function