Oracle Database 11g: Programm with PL/SQL

Beschreibung

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.

Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.

Conditionally control code flow (loops, control structures)

Design and use PL/SQL packages to group and contain related constructs.

Create triggers to solve business challenges.

Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.

Create anonymous PL/SQL blocks of code.

Declare PL/SQL Variables

Zielgruppe

Sie sind Systemanalytiker, PL/SQL-Entwickler, Formsentwickler, Datenbankadministrator, Technischer Berater oder Entwickler.

Voraussetzungen

Besuch der Seminare "Oracle Database 11g: Professioneller Einstieg in Oracle SQL" (D49988) oder "Oracle Database 11g: SQL Fundamentals I" (D49996) und "Oracle Database 11g: SQL Fundamentals II" (D49994). Sie sollten auch Erfahrung in der Programmierung haben.

Kursinhalte

• Introduction



• Introduction to PL/SQL



• Declaring PL/SQL Identifiers



• Writing Executable Statements



• Interacting with the Oracle Server



• Writing Control Structures



• Working with Composite Data Types



• Using Explicit Cursors



• Handling Exceptions



• Creating Stored Functions



• Creating Packages



• Working With Packages



• Using Oracle-Supplied Packages in Application Development



• Using Dynamic SQL



• Design Considerations for PL/SQL Code



• Creating Triggers



• Creating Compound, DDL, and Event Database Triggers



• Using the PL/SQL Compiler



• Managing PL/SQL Code



• Managing Dependencies