Answer Posted / radha sri seshu.kolla

I THINK TRIGGER FIRES FIRST, BCZ WHEN U WRITE A TRIGGER
LIKE 'BEFORE INSERT ON EMP' EVENT. THIS TRIGGER WILL FIRE
IMMEDEATELY BEFORE THE DATA IS ABOUT TO INSERT IN THE
TABLE.WHERE AS IN THE CASE OF CONSTRAINTS, WHEN YOU INSERT
THE DATA,THE DATA GOES FOR CONSTRAINT VALIDATION THEN THE
DATA WILL BE REJECTED(IF THE DATA VIOLATES THE CONSTRAINT
RULE). I AM NOT 100% SURE. THIS IS JUST MY IMAGINATION.

Sql technical questions

1273

---

Does execute immediate commit?

1216

---

How do I know if I have sql express or standard?

1028

---

What is having clause in sql?

963

---

What's the difference between a primary key and a clustered index?

986

---

What is a variable in sql?

1001

---

When can we use the where clause and the having clause?

1016

---

What is #table in sql?

1092

---

what is normalization? : Sql dba

1082

---

What is procedure in pl sql?

1040

---

Can I create table without primary key?

997

---

What is procedure and function in sql?

997

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1204

---

What is a trigger in sql?

1200

---

Can delete statement be rollbacked?

984

---