Please enable JavaScript.
Coggle requires JavaScript to display documents.
PL/SQL, Coke popping out - Example for Trigger, Vikram raising hand…
PL/SQL
Combination of SQL along with the procedural features of programming languages
PROCEDURES
PL/SQL block which performs one or more specific tasks
Header
Contains the name and the parameters passed to the procedure
Body
Declaration section
Execution section
Exception section
PARAMETERS
IN parameter
Value of the parameter cannot be overwritten
OUT parameter
Value of the parameter can be overwritten
INOUT parameter
Value of the parameter can be overwritten
Create Procedure
Call Procedure
Drop Procedure
FUNCTIONS
Similar to PL/SQL Procedure
Must always return a value
PARAMETERS
IN
OUT
INOUT
Create or Replace Function
TRIGGERS
Invoked automatically whenever a specified event occurs
Stored programs
TRIGGERING EVENT
DML Statements
DDL Statements
Database Operations
Creating a Trigger
IMAGE ANALOGY
VIDEO ANALOGY
https://drive.google.com/file/d/18WYJKFulp7qPt4EqTWsD5k-fJN4qV6JY/view?usp=sharing
Procedure
https://drive.google.com/file/d/18bYYnrRWIJPqCzAl1vVCvhmtWDIKaiof/view?usp=sharing
Function
Coke popping out - Example for Trigger
Vikram raising hand automatically - Example for Trigger
