Answer / 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

Answer / dhananjay kumar singh

I am know trigger is fire firstly because trigger are
automatically fired and constraint are not fired
automatically.

Answer / dhanashree

Trigger will fire first because the trigger fires at the
table level and the constraint fires at column level

Answer / roopa

trigger fires first.

Can we create table in function?

0 Answers  

---

What is a sql statement?

0 Answers  

---

What is latest version of sql?

0 Answers  

---

How do I sort a table in sql?

0 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Does sql use python?

0 Answers  

---

What are packages in pl sql and also explain its advantages?

0 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---

How many tables can a sql database have?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

What are the types of variable use in pl sql?

0 Answers  

---