PL-SQL
-
· Introduction to PL/SQL
PL/SQL Overview
Benefits of PL/SQL Subprograms
Overview of the Types of PL/SQL blocks
Create a Simple Anonymous Block
Generate Output from a PL/SQL Block
· Standard Functions
General functions
Number functions
Other functions
· PL/SQL Identifiers
List the different Types of Identifiers in a PL/SQL subprogram
Usage of the Declarative Section to define Identifiers
Use variables to store data
Identify Scalar Data Types
The %TYPE Attribute
What are Bind Variables?
Sequences in PL/SQL Expressions
· Write Executable Statements
Describe Basic PL/SQL Block Syntax Guidelines
Comment Code
Deployment of SQL Functions in PL/SQL
Converting Data Types
Nested Blocks
Identify the Operators in PL/SQL
· Interaction with the Oracle Server
Invoke SELECT Statements in PL/SQL to Retrieve data
Dynamic SQL
Data Manipulation in the Server Using PL/SQL
SQL Cursor concept
Usage of SQL Cursor Attributes to Obtain Feedback on DML
Save and Discard Transactions
· Control Structures
Conditional processing Using IF Statements
Conditional processing Using CASE Statements
Use simple Loop Statement
Use While Loop Statement
Use For Loop Statement
Describe the Continue Statement
· Composite Data Types
Use PL/SQL Records
The %ROWTYPE Attribute
Insert and Update with PL/SQL Records
Associative Arrays (INDEX BY Tables)
Examine INDEX BY Table Methods
Use INDEX BY Table of Records
· Explicit Cursors