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 usage of when clause in trigger?

576

---

What is input buffer in sql*plus?

648

---

Can we alter stored procedure?

557

---

What is a temp table?

578

---

How to run sql functions in pl/sql?

554

---

---

Which is faster view or stored procedure?

521

---

What is secondary key?

520

---

What is sql procedures and functions?

542

---

Mention what pl/sql package consists of?

549

---

What is a design view?

533

---

What is the difference between database trigger and stored procedure?

563

---

Mention what are the benefits of pl/sql packages?

544

---

What is a sql select statement?

578

---

Why stored procedure is better than query?

518

---

what is self-join? : Sql dba

583

---