Write a PL/SQL program for a trigger

Write a PL/SQL program for a trigger.

PL/SQL program for tracking operation on a emp table.
Create or Replace Trigger EmpTracking
Before Insert or Delete or Update on Emp
For each row
Declare
Begin
   If Inserting then
   /*Can perform operations just before record is inserted into the emp table*/
   Else if Updating then
   /*Can perform operations just before record is about to be updated*/
   Else if Deleting then
   /*Can perform operations just before record is about to be deleted*/
   End If
End EmpTracking
What are SQLCODE and SQLERRM? Why are they important for PL/SQL developers?
SQLCODE: It returns the error number for the last encountered error. SQLERRM:...
Difference between SQL and PL/SQL
SQL is Structured Query Language comprising of Data Definition Language (DDL) and Data Manipulation Language (DML)...
Write a PL/SQL program for a function
Write a PL/SQL program for a function - PL/SQL program...
Post your comment