Oracle 11g: PL/SQL
Topics
1. PL/SQL Structure
·
Variables
·
Data
type
2. Creating the
Executable Section
·
Comments6
·
Literals
·
Operator
·
Output
Statement
·
Accepting
input from user
·
Variable
scope
·
Function
·
Programs
using SQL Statements in PL/SQL
3. Writing Control
Structures
·
If
statement in PL/SQL
·
If...else
statement in PL/SQL
·
Else
if ladder statement in PL/SQL
·
LOOPs
in PL/SQL
4. Working with
Composite Data Types
·
PL/SQL
Records
·
Collections
5. Cursors
·
PL/SQL
Attributes Cursor Attributes
·
Using
cursor with for …loop
6. Exception
Handling
·
What
is an Exception?
·
How
to handle Exception?
·
Predefined
Exception
·
Get
information about error with –SQLCODE and SQLERRM
·
Non
Predefined Error
·
User
Defined Exception
7. Stored
Procedures
·
Advantages
of procedures
·
Creating
procedure
·
Formal
and actual parameters in procedure
·
Using
Anonymous block to invoke a procedure
·
Default
option for parameters
·
Using
Sub Procedures
·
Calling
procedure from another procedure
·
Handled
and Unhandled Exception when procedure called
·
Delete
procedure
8. Functions
·
Advantages
of Functions
·
Calling
function in SQL statement
·
Restriction
on calling function in SQL statement
·
Deleting
a Function
·
Difference
between function and procedure
9. Packages
·
Advantages
of packages
·
Package
Structure
·
Executing
the procedure and function
·
Removing
package
10. Triggers
·
Creating
a trigger
·
Accessing
a column using row trigger
·
Using
Statement trigger
·
Modifying
a Trigger
·
Enabling
and Disabling a trigger
·
Dropping
a trigger
11. Oracle Architecture-
Complimentary Session