Oracle Database: PL/SQL Fundamentals

Teilnehmerkreis

Teilnehmerkreis

• Systemanalytiker
• PL/SQL-Entwickler
• Technischer Berater
• Formsentwickler

Vorkenntnisse

Empfehlenswerte verwandte Kurse:

• Using Java - for PL/SQL and Database Developers

This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.

• Oracle Database: Develop PL/SQL Program Units

This Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages.

Kursziele

Kursziele

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

Kursthemen

Introduction

• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Using SQL Statements within a PL/SQL Block
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Creating Stored Procedures and Functions