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

Do we need commit after truncate?

1052

---

How many joins can you have in sql?

898

---

what are rollup and cube in t-sql? : Transact sql

1063

---

How is sql used in oracle?

981

---

Is sql microsoft?

1003

---

What is view? Can we update view

1386

---

Advantages and disadvantages of stored procedure?

1077

---

What are secondary keys?

943

---

What is difference between primary and secondary key?

996

---

How many types of relationship are there?

1000

---

What does data normalization mean?

920

---

Is sql a backend?

986

---

What is use of package in pl sql?

977

---

what is sql in mysql? : Sql dba

1148

---

What are different types of queries in sql?

1074

---