create table dept(deptno number(2,0),dname varchar2(14),loc varchar2(13),constraint pk_dept primary key (deptno)) ; create table emp(empno number(4,0),ename varchar2(10),job varchar2(9),mgr number(4,0),hiredate date,sal number(7,2),comm…
What is a Trigger Is a PL/SQL block or PL/SQL procedure associated with a table, view, schema, or the database…
Tough job for a functional or business analyst is to understand the nuance of Database. It is not that much…