GitHub

README.md

PL/SQL can offers a great deal of offers and tools that can manage big production databases. One of most useful features Oracle PL/SQL offer are triggers. Triggers are specialized programs that can ...
GitHub

Ex. No: 5 Creating Triggers using PL/SQL

CREATE TABLE employee7( empid NUMBER,empname VARCHAR(10),dept VARCHAR(10), salary NUMBER); CREATE TABLE sal_log1 (log_id NUMBER GENERATED ALWAYS AS IDENTITY,empid NUMBER,empname ...