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 an inner and outer join?

737

---

Will truncate release space?

684

---

What are analytic functions in sql?

745

---

Explain the difference between sql and mysql.

761

---

What language is oracle sql developer?

717

---

What are the methods of filing?

676

---

Explian rowid, rownum?

759

---

What is the cause of mutating table error and how can we solve it?

795

---

Write the alter statement to enable all the triggers on the t.students table.

853

---

What is a trigger in sql?

895

---

What are the advantages of normalization?

793

---

Is pl sql a programming language?

719

---

What are the query optimization techniques?

711

---

What is a design view?

705

---

What is the process of debugging?

741

---