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 the difference between sql and isql*plus?

1160

---

how to get a list of columns in an existing table? : Sql dba

1001

---

What is sql and explain its components?

1113

---

What are the different operators available in sql?

1057

---

Is ms sql traffic encrypted?

960

---

How do you use a while loop in pl sql?

1050

---

What is sql rowcount?

1068

---

how to escape special characters in sql statements? : Sql dba

1079

---

Can we perform dml on view?

1114

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1121

---

what is sql in mysql? : Sql dba

1236

---

How much does sqlite cost?

1094

---

how does a local variable is defined using t-sql? : Transact sql

1057

---

What is sql*loader and what is it used for? : aql loader

1246

---

What is the purpose of primary key?

1070

---