Course Detail

DEFINING VARIABLES AND DATATYPES:

• PLSQL Block Structure, Block Type
• Using Variables in PLSQL
• Types of Variables & Naming Rules Variable Initialization
• PLSQL variable Non PLSQL variable
• Scalar variable, Reference Variable
• Composite variable
• Recognizing PLSQL Lexical Units
• Recognizing Data Types
• Using Scalar Data Types
• Writing PLSQL Executable Statements
• Nested Blocks and Variable Scope
• Good Programming Practices
• Boolean Variables and HANDLING Non-PLSQL Variables DBMS_OUTPUT.PUT_LINE
• %TYPE and %ROWTYPE

PROGRAM STRUCTURES TO CONTROL EXECUTION FLOW:

• Conditional Control: IF,IF ELSE, IF ELSIF Statements
• Conditional Control: CASE Statements
• Iterative Control: Basic Loops
• Nested loop and Lable
• Iterative Control: Nested Loops
• GOTO Statement
• Iterative Control: WHILE and FOR Loops
• Real time Example of program using Conditional statement and Loop

USING CURSORS AND PARAMETERS:

• When we go for Cursor.
• Type of Cursor
• Defining Static and Dynamic Cursor
• Implicit Cursor, Explicit Cursor, Parameterized Cursor
• Introduction to Explicit Cursors.
• Cursor Attributes , Which attributes cannot used in Implicit cursor
• Declare the cursor, Open the Cursor ,FETCH the Data from Cursor, Close the Cursor.
• Cursor FOR Loop
• Cursors with Parameters
• ROWCOUNT using in DML operation inside the block.
• FOR CURSOR
• Using Cursors for UPDATE and WHERE CURRENT OFF
• Using Multiple Cursors

PACKAGE:

• Reason to use Package
• Create the package
• Identify the advantage of Package
• Describing the package
• Components in package
• Global variable
• Forward Declaration, and Procedure overloading
• Create The Package specification and Package Body
• Implement the Business logic in the Package
• Implements the Cursor and Exception in the Package efficiently
• View the source code using the data dictionary table
• Compile and Drop the Package

TRIGGER:

• Describe the trigger
• Purpose of trigger
• Identify the trigger events type and body/li>
• Type of triggers
• Syntax for creating Row level trigger and statement level trigger
• And difference
• Instead of trigger
• Create the DDL,Database(logon and logoff) trigger
• Create and Drop the trigger
• View the Meta data information about the trigger
• Mutating error
• How to avoid the mutation error
• Create the Compound trigger to avoid the mutating error
• Describe the Pragma_autonomous_transcation
• Using data dictionary ALL_TRIGGERS
• Manage dependencies
• Overview of Schema object dependencies
• Finding out the Object Dependencies using the USER_DEPENDENCIES
• Invalidation of object dependencies

EXCEPTION HANDLING:

• Understand the Exception
• Handle exception in PLSQL Blocks.