Upon completion of this course, the student will be able to: Retrieve data using Pl/SQL. Manipulate data using PL/SQL. Control transaction. Build conditional constructs, looping constructs and Boolean conditions. Create and manage cursors. Handle exceptions during run time.
Unit 1: Accessing Databases Using PL/SQL
- Retrieving Data Using PL/SQL
- Manipulating Data Using PL/SQL
- Controlling Transactions
Unit 2: Controlling Structures in PL/SQL
- Using Conditional Constructs
- Using Boolean Conditions
- Working with Loop Statements
Unit 3: Working with Cursors
- Defining Cursor Types
- Processing of Implicit Cursors
- Controlling Explicit Cursors
- Using Explicit Cursor Attributes
- Working with Advanced Explicit Cursors
- Using the Cursor FOR Loop
- Using the SELECT FOR UPDATE Cursor
Unit 4: Handling Exceptions in a PL/SQL Block
- Raising Exceptions
- Trapping Exceptions
- Handling Unhandled Exceptions