Oracle Database: PL/SQL Fundamentals

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Learn to:

• Conditionally control code flow (loops, control structures)
• Use explicit cursors
• Handle runtime errors
• Describe stored procedures and functions
• Work with composite data types
• Declare PL/SQL variables
• Create anonymous PL/SQL blocks, stored procedures and functions
• Declare identifiers and trap exceptions.

Benefits to you: 

Enrolling in this course will teach you how to extend the functionality of the SQL language with PL/SQL language to write application code. Your organization can then realize the full benefit of utilizing Oracle best practices.

Audience:

• Technical Consultants, System Analysts, PL/SQL Developers, Forms Developers

Prerequisites:

• Oracle Database: Introduction to SQL

Course objectives:

• Handle runtime errors
• Describe stored procedures and functions
• Use cursors to process rows
• Design PL/SQL anonymous block that execute efficiently
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)

Other relevant courses