Answer Posted / pradeep

TRigger fires fist, it dose not matter is it befor or
after, please see the below trigger. Even i am not entering
not a valid DEPTNO, still trigger fires first and then
constraint error comes


CREATE OR REPLACE TRIGGER EMPTRIGGER after INSERT ON EMP
FOR EACH ROW
BEGIN
--- RAISE_APPLICATION_ERROR(-20201,'INVALID NUMBER');
dbms_output.put_line(
'in triggeerssssssssssssssssssssssssssssssssssssssssss');
END;
SQL> /

Trigger created.

SQL> INSERT INTO EMP(EMPNO,DEPTNO) VALUES(3333,50);
in triggeerssssssssssssssssssssssssssssssssssssssssss
INSERT INTO EMP(EMPNO,DEPTNO) VALUES(3333,50)
*
ERROR at line 1:
ORA-02291: integrity constraint (SCOTT.FK_DEPTNO) violated -
parent key not
found

What is pl sql architecture?

965

---

What is an exception in pl/sql?

1095

---

Can a trigger call a stored procedure?

1075

---

What is sql profiling in oracle?

1069

---

What is cursor and its types?

1080

---

Why do we need unique key in a table?

962

---

Can a table contain multiple foreign key’s?

1004

---

how to escape special characters in sql statements? : Sql dba

1041

---

What is the purpose of cursors in pl/sql?

1138

---

how to convert character strings to dates? : Sql dba

1067

---

What does (+) mean in sql joins?

1071

---

What is the difference between sql, mysql and sql server?

1111

---

Explain what is a database?

1089

---

Explain the insert into statements in sql?

1010

---

Can you inner join the same table?

996

---