Answer Posted / lakkireddy ashok

Always trigger will fire first

eg:create table T_CHK (a number check (A < 99));

INSERT INTO T_CHK VALUES(101);

ORA-02290: check constraint (APPS.SYS_C00207769) violated

if u create trigger
CREATE TRIGGER CHKT BEFORE INSERT ON T_CHK
FOR EACH ROW
BEGIN
IF :NEW.A >100 THEN
RAISE_APPLICATION_ERROR(-20011,'VALUES SHOULD BE < 100');
END IF;
END;

INSERT INTO T_CHK VALUES(101);

ORA-20011: VALUES SHOULD BE < 100
ORA-06512: at "APPS.CHKT", line 3
ORA-04088: error during execution of trigger 'APPS.CHKT'

if u don't create trigger then constraint will be first otherwise if u create trigger to the same table with same DML operations here trigger will fire first instead of constraint firing

what is the difference between group by and order by in sql? : Sql dba

1124

---

How long will it take to learn pl sql?

934

---

What is pl sql collection?

961

---

Is big data nosql?

942

---

How do I partition in sql?

961

---

What is lookup table in sql?

1041

---

What is the difference between delete and truncate statement in sql?

1067

---

How do you run a query?

989

---

what are the drivers in mysql? : Sql dba

1017

---

Can instead of triggers be used to fire once for each statement on a view?

962

---

How to Declare Fixed Length String Value In PL SQL

1153

---

What does (+) mean in sql joins?

1059

---

Are null values same as that of zero or a blank space?

1024

---

what is data control language? : Sql dba

1024

---

What are the types of join in sql?

1098

---