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:

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)

Andre relevante kurs

15. april
5 dager
Virtual Classroom On Demand
3 dager
Virtual Classroom On Demand
5 dager
Classroom Virtual On Demand