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

how to create a new view in mysql? : Sql dba

986

---

What is the usage of the distinct keyword?

1274

---

What is offset in sql query?

1176

---

Describe different types of general function used in sql?

1092

---

Why do we use set serveroutput on?

1011

---

What is pl/sql language case sensitive?

1181

---

What is the difference between sql and mysql?

1175

---

What is pivot in sql?

971

---

What is the difference between left outer join and left join?

1034

---

What are sql queries used for?

1079

---

Which join is default?

1013

---

What does count (*) mean in sql?

1653

---

Explain the difference between rename and alias?

1064

---

Which command is used to delete a trigger?

1405

---

How long does it take to learn pl sql?

1104

---