Curriculum
- 1 Section
- 6 Lessons
- 2 Days
Expand all sectionsCollapse all sections
- Topics6
- 1.1CHOOSING A SQL & PL/SQL INTERFACE USING SQL developer USING SQL*plus USING application express USING jdeveloper studio
- 1.2LANGUAGE FEATURES UNDERSTANDING pl/sql STRUCTURE of a pl/sql program block USING pl/sql from sql*plus
- 1.3DECLARE CLAUSE ABOUT the declare clause DECLARE simple types DECLARE complex types TYPE … table TYPE … record
- 1.4BEGIN CLAUSE ABOUT the begin clause PERFORMING data manipulation LOGIC control & branching LOOP IF-then-else CASE
- 1.5EXCEPTION CLAUSE ABOUT the exception clause ISOLATING the specific exception PRAGMA exception_init SQL%ROWCOUNT & select … into
- 1.6EXPLICIT CURSORS ABOUT explicit cursors ADVANCED cursor techniques ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS