|
Description: |
You will receive a hands-on introduction to the Oracle11g PL/SQL procedural language for SQL. You will cover how to insert, update, and delete data, control data sharing and locking, debug and use error report procedures, and develop database triggers, stored procedures and functions for future reuse. You can learn ... - The PL/SQL Environment and Program Structure
- Update, Insert and Delete Statements
- Error Report Functions
- Debugging Procedures
- Logical Comparisons
- To define, store and Execute Procedures
- To define, store and execute Functions
- To create Package Specifications and Package Bodies
- To create composite datatypes
- To work with implicit and explicit cursors
Who Needs to Attend: Anyone who needs to extract and organize information from an Oracle database, including adding, updating, and deleting data, and debug and use error report procedures, and develop database triggers, stored procedures and functions for future reuse. I.E. Application designers, developers, database administrators, and End Users. |
|
