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

Write a sql query to find the names of employees that begin with ‘a’?

1005

---

How to change sql*plus system settings?

1048

---

Are stored procedures faster than dynamic sql?

1029

---

What is the difference among union, minus and intersect?

991

---

Are stored procedures compiled?

915

---

describe mysql connection using mysql binary. : Sql dba

1059

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1138

---

What is the use of non clustered index?

986

---

what is table? : Sql dba

1056

---

What are local and global Indexes and where they are useful.

1437

---

Explain unique key in sql.

1003

---

How do I remove sql plus from windows 10?

1090

---

What is input buffer in sql*plus?

1212

---

Does view store data in sql?

959

---

Why function is used in sql?

938

---