1. Choosing a sql & pl/sql interface
- Using sql developer
- Using sql*plus
- Using application express
- Using jdeveloper studio
2. Language features
- Understanding pl/sql
- Structure of a pl/sql program block
- Using pl/sql from sql*plus
3. Declare clause
- About the declare clause
- Declare simple types
- Declare complex types
- Type ... Table
- Type ... Record
4. Begin clause
- About the begin clause
- Performing data manipulation
- Logic control & branching
- Loop
- If-then-else
- Case
5. Exception clause
- About the exception clause
- Isolating the specific exception
- Pragma exception_init
- Sql%rowcount & select...into
6. Explicit cursors
- About explicit cursors
- Advanced cursor techniques
- Advanced programming: declared subprograms
|
