Oracle PL/SQL Programming - Basic Level

Oracle PL/SQL Programming - Basic Level

This course in the entry level to learn about PL/SQL programming for Oracle databases. It provides the essential fundamentals need to build the first, initiative PL/SQL block of codes.

Course Outline

• Declaring PL/SQL Variables
• Recognize valid and invalid identifiers
• List the uses of variables, declare and initialize variables, use bind variables
• List and describe various data types using the %TYPE and %ROWTYPE attributes
• Writing Executable Statements

Identify lexical units in a PL/SQL block

• Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
• Describe when implicit conversions take place and when explicit conversions have to be dealt with
• Write nested blocks and qualify variables with labels
• Write readable code with appropriate indentation

Writing SQL in PL/SQL

• Create PL/SQL executable blocks using DML and transaction control statements
• Make use of the INTO clause to hold the values returned by a SQL statement
• Using implicit cursor attributes to determine the outcome of SQL inside PL/SQL

Writing Control Structures

• Identify the uses and types of control structures (IF, CASE statements and expressions)
• Construct and identify loop statements
• Use EXIT and CONTINUE statements inside loops

Define PL/SQL exceptions

• Recognize unhandled exceptions
• Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
• Propagate exceptions