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

Course Enquiry