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.

Determine if oracle date is on a weekend?

1001

---

What is record type in pl sql?

954

---

What is the most restrictive isolation level? : Transact sql

1048

---

What is Collation Sensitivity ? What are the various type ?

919

---

What are different sql data types?

984

---

What is trigger explain it?

977

---

What is rollback?

1055

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1005

---

what is recursive stored procedure? : Sql dba

944

---

Show the two pl/sql cursor exceptions.

1131

---

How does cross join work in sql?

971

---

How to move files from one directory to another in pl sql?

1146

---

How can check sql version from command line?

1031

---

how to drop an existing table in mysql? : Sql dba

999

---

How do you concatenate in sql?

994

---