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 sql and also describe types of sql statements?

1066

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1065

---

What is information schema in sql?

1070

---

What does partition by mean in sql?

960

---

What are views in sql?

986

---

How do I save the results of sql query in a file?

976

---

What is sql*loader?

1187

---

What is a loop in sql?

982

---

What is %type in pl sql?

963

---

what is a field in a database ? : Sql dba

1055

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

983

---

What is procedure explain with program?

1017

---

What is count * in sql?

993

---

How do I find duplicates in two columns?

1167

---

how to see the create table statement of an existing table? : Sql dba

1011

---