Answer Posted / radha sri seshu.kolla

NOW I AM 100% SURE THAT TRIGGER WILL FIRE FIRST.
TRY THIS CODE YOU WILL UNDERSTAND

------------------------------------------------------------
CREATE OR REPLACE TRIGGER EMPTRIGGER BEFORE INSERT ON EMP
FOR EACH ROW
BEGIN
FOR I IN (SELECT EMPNO FROM EMP)
LOOP
IF I.EMPNO=:NEW.EMPNO THEN
RAISE_APPLICATION_ERROR(-20201,'INVALID NUMBER');
END IF;
END LOOP;
END;
/
INSERT INTO EMP(EMPNO,DEPTNO) VALUES(7788,10)
---------------------------------------------------------
FEEL FREE TO TALK WITH ME ON 9966409914. IF NOT RINGING
THEN TRY 9966112520

What is transaction control language (tcl)?

1139

---

Define sql delete statement.

1014

---

How do you bind variables in pl sql?

1093

---

what is dbms? : Sql dba

994

---

What are the usages of sql?

1058

---

What is dml with example?

1087

---

What are the three pl sql block types?

1009

---

How do I remove duplicates in two columns?

1065

---

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

986

---

explain commit and rollback in mysql : sql dba

1015

---

What has stored procedures in sql and how we can use it?

1082

---

how to include character strings in sql statements? : Sql dba

1071

---

What are the commands used in sql?

1079

---

Does a user_objects view have an entry for a trigger?

1011

---

How do I debug a stored procedure?

1113

---