'Row trigger' diaporamas de présentation

PL/SQL

PL/SQL. Procedural Language for SQL (PL/SQL) is an extension of Oracle SQL. The basic intent of PL/SQL is. increase the expressiveness of SQL. process query results in a tuple-oriented way. develop modular database application programs. reuse program code, and.

571 views • 32 slides

Creating Triggers

Creating Triggers. Objectives. After completing this lesson, you should be able to do the following: Describe the different types of triggers Describe database triggers and their uses Create database triggers Describe database trigger-firing rules Remove database triggers.

295 views • 29 slides

Creating Triggers

Creating Triggers. Objectives. After completing this lesson, you should be able to do the following: Describe the different types of triggers Describe database triggers and their uses Create database triggers Describe database trigger-firing rules Remove database triggers.

287 views • 28 slides

Triggers

371 views • 21 slides

Triggere

Triggere. Mutasjoner i basen. Triggers. Triggers are stored procedures that execute automatically when something (event) happens in the database: : data modification (INSERT, UPDATE or DELETE) : schema modification : system event (user logon/logoff) Types of triggers

251 views • 11 slides

Triggere

Triggere. Mutasjoner i basen. Triggers. Triggers are stored procedures that execute automatically when something (event) happens in the database: : data modification (INSERT, UPDATE or DELETE) : schema modification : system event (user logon/logoff) Types of triggers

114 views • 11 slides