I\'m getting compilation errors on the following SQL Command. What am I doing wr
ID: 664365 • Letter: I
Question
I'm getting compilation errors on the following SQL Command. What am I doing wrong? I have attached the SQLs that I have tried, but get the same error message:
1. Create a trigger to store a copy of any record deleted from the employee table into a table called Emp_temp. Assume that the Emp_temp table has the same structure as the employee table.
SQL> CREATE OR REPLACE TRIGGER EMP_DEL
2 AFTER DELETE ON EMPLOYEES
3 FOR EACH ROW
4 BEGIN
5 INSERT INTO EMP_TEMP
6 (EMPLOYEE_ID,EMPLOYEE_NAME,JOB_ID,JOB_DESCRIPTION,HOD,HIREDATE,SALARY,DEPAR
TMENT_ID)
7 SELECT
8 :OLD.EMPLOYEE_ID,
9 :OLD.EMPLOYEE_NAME,
10 :OLD.JOB_ID,
11 :OLD.JOB_DESCRIPTION,
12 :OLD.HOD,
13 :OLD.HIREDATE,
14 :OLD.SALARY,
15 :OLD.DEPARTMENT_ID
16 FROM DUAL;
17 END;
18 /
Warning: Trigger created with compilation errors.
SQL> CREATE OR REPLACE TRIGGER EMP_DEL
2 AFTER DELETE ON EMPLOYEES
3 FOR EACH ROW
4 BEGIN
5 INSERT INTO EMP_TEMP
6 (EMPLOYEE_ID,EMPLOYEE_NAME,JOB_ID,JOB_DESCRIPTION,HOD,HIREDATE,SALARY,DEPAR
TMENT_ID)
7 VALUES (:OLD.EMPLOYEE_ID, :OLD.EMPLOYEE_NAME, :OLD.JOB_ID, :OLD.JOB_DESCRIP
TION, :OLD.HOD, :OLD.HIREDATE, :OLD.SALARY, :OLD.DEPARTMENT_ID);
8 END;
9 /
Warning: Trigger created with compilation errors.
Explanation / Answer
Your 1st sql was right only error is with line 6
(EMPLOYEE_ID,EMPLOYEE_NAME,JOB_ID,JOB_DESCRIPTION,HOD,HIREDATE,SALARY,DEPAR
TMENT_ID)
Correct is - <EMPLOYEE_ID,EMPLOYEE_NAME,JOB_ID,JOB_DESCRIPTION,HOD,HIREDATE,SALARY,DEPAR
TMENT_ID>
Please find below SQL which created a trigger to store a copy of any record deleted from the employee table into a table called Emp_temp.
SQL> CREATE OR REPLACE TRIGGER EMP_DEL
2 AFTER DELETE ON EMPLOYEES
3 FOR EACH ROW
4 BEGIN
5 INSERT INTO EMP_TEMP
6 <EMPLOYEE_ID,EMPLOYEE_NAME,JOB_ID,JOB_DESCRIPTION,HOD,HIREDATE,SALARY,DEPAR
TMENT_ID>
7 SELECT
8 :OLD.EMPLOYEE_ID,
9 :OLD.EMPLOYEE_NAME,
10 :OLD.JOB_ID,
11 :OLD.JOB_DESCRIPTION,
12 :OLD.HOD,
13 :OLD.HIREDATE,
14 :OLD.SALARY,
15 :OLD.DEPARTMENT_ID
16 FROM DUAL;
17 END;
18 /
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.