Course Objective:
To make our trainee expert in the following topics theoretically & practically.
- Data Types: Character, Number, Boolean, Date, LOB Concept
- Variable Identifiers Concept
- Collections: Varrays, Nested & Index by Tables Concept
- Records Type Concept
- IF THEN ELSE Statement: ELSIF, NESTED-IF Concept
- CASE Statement
- LOOP: FOR LOOP, WHILE LOOP Concept
- Stored Procedure & Functions Concept
- Exception Handling: Raise User-defined Exception Concept
- Insert, Update, Delete & Select Into Concept
- Cursor: Implicit, Explicit, Cursor FOR Loop Concept
- BULK COLLECT: FORALL Concept
- Autonomous Transaction in Oracle PL/SQL: Commit, Rollback Concept
- Package: Type, Specification, Body Concept
- Trigger Tutorial: Instead of, Compound Concept
- Object Types Concept
- Dynamic SQL: Execute Immediate & DBMS_SQL Concept
- Nested Blocks & Variable Scope in Oracle PL/SQL Concept
Note- We train our trainee until they are satisfied.
