PL/SQL Online Training (One to One Online Training)
Duration : 6 Sessions
For Course Fee, Demo and Time Slots, Contact at
[email protected] |
[email protected] | +91 – 9581017828 |
http://www.oracleappstechnical.com
PL/SQL Course Contents
Introduction to PL/SQL
Advantages of PL/SQL
The PL/SQL Block
Basic PL/SQL Block Structure
The Declaration Section
The Execution Section
The Exception Section
Generation Output
Variables And Constants
Data types
Scalar Data types
Composite Data types
Variables (%type, %rowtype)
Variable Assignment
Scope of Variables
Constants
Writing Sample programs demonstrating all above Functionalities
Conditions and Loops
Conditional Control
Iterative Control
Guidelines
Sample, While, and For Loops
While Loop
For Loop
Cursors
Implicit and Explicit Cursors
Cursors Actions
Declaring a Cursors
Opening a Cursors
Fetching Data from ad Cursor
Closing a Cursor
Cursor Attributes
Cursors and Loops
Cursors For Loops
Exception Handling
Guidelines
Types of Exceptions
Named System Exceptions
Named User-Defined Exceptions
Unnamed System Exceptions
Unnamed User-Defined Exceptions
SQL ERRM and SQL Code
Procedures
Writing Procedures using Oracle SQL,PLSQL
Types of Program Units
Named and Unnamed Block Structures
Diff between Anonymous Blocks and named Blocks
Procedures Parameters
Parameter Modes
IN
Out
IN Out
Testing Procedure from anonymous blocks
Calling procedure from another procedure
User Defined Functions
Using Functions within Oracle
Difference ways of Callings a function
Named Notation
Functions
Function Parameters
Referencing a Function
Packages
Defining and Using Packages
Advantages of Using Packages
Overloading
Dependency
Abstraction – Information Hiding
Inheritance
Defining Global Variables
Database Triggers
Trigger Types
Trigger Events
Trigger Restrictions
Trigger Body
Complication of Database Triggers
Trigger Syntax
Usage of Instead of Triggers
An Overview of Oracle Large Objects
BLOB
CLOB
PL/SQL Table
VARRAY
BFILE
Nested Tables
FAQ’S in PL/SQL
About Training
I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 10 Yrs Exp on Oracle Apps and 14 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, OAF, SQL, PL/SQL and D2K. I have Provided Training for 1000+ Professionals Most of them are Working in Real Time now.
Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, OAF, SQL, PL/SQL and D2K at
[email protected] |
[email protected] | +91 – 9581017828 |
http://www.oracleappstechnical.com
LinkedIn profile -
https://in.linkedin.com/in/sridevi-koduru-9b876a8b
We are Specialized Online Trainers on Oracle Apps Technical, Oracle Financial Functional, Oracle Apps SCM.
