|
Training Syllabus
|
NCORC011
-
Oracle 11g Introduction To PL SQL
|
|
Durasi : 5 hari
- Introduction to PL/SQL
- Declaring PL/SQL Identifiers
- Writing Executable Statements
- Interacting with the Oracle Server
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Creating Stored Procedures
- Creating Stored Functions
- Creating Packages
- Working With Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Design Considerations for PL/SQL Code
- Creating Triggers
- Creating Compound, DDL, and Event Database Triggers
- Using the PL/SQL Compiler
- Managing PL/SQL Code
- Managing Dependencies
|
|
|