Oracle PL/SQL Stored Program Units (STA_OSPU)

Global Knowledge Network Netherlands bv

Oracle PL/SQL Stored Program Units Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français -

Price
from €1,885
Level
Not specified
Kind
Course
Subject
Automation and IT

More information and registration at Global Knowledge Network Netherlands bv

Description

Oracle PL/SQL Stored Program Units Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais. The Oracle PL/SQL Stored Program Units course provides practical experience in developing and writing triggers,functions,procedure Oracle PL/SQL Stored Program Units Training Course Course Contents - DAY 1 Course Introduction Administration and Course Materials Course Structure and Agenda Delegate and Trainer Introductions Session 1: TRIGGERS DML Triggers The CREATE TRIGGER Statement Writing Trigger Code INSTEAD OF Triggers Calling Procedures from Triggers Coding Restrictions System Event and DDL Triggers Attribute Functions Compound Triggers Create Trigger Follows Clause Managing Triggers Privileges Required for Triggers Dictionary Information Concerning Triggers Session 2: PROCEDURES What is a Procedure? The CREATE PROCEDURE Statement Procedure Parameters Invoking Procedures Local Subprograms Named Association Parameter Passing Definer's Rights and

Start dates

Start End Place Price
18 November 2026 20 November 2026 Online €1,885
3 February 2027 5 February 2027 Online €1,885
24 February 2027 26 February 2027 Online €1,885
21 April 2027 23 April 2027 Online €1,885