Answer Posted / vijay kumar s

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

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;

SQL> INSERT INTO T_CHK VALUES(100);
INSERT INTO T_CHK VALUES(100)
*
ERROR at line 1:
ORA-02290: check constraint (SVR.SYS_C00301152) violated

ABOVE ONE CLEARLY TELLS

contraints will fire first.

What is trigger explain it?

1078

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1205

---

Mention what does the hierarchical profiler does?

1138

---

what are the different type of sql's statements ? : Sql dba

977

---

How do sql triggers work?

1091

---

what are tables and fields? : Sql dba

1103

---

How do you clear the screen in sql?

1122

---

What is the difference between a procedure and a function?

1212

---

Can a commit statement be executed as part of a trigger?

1102

---

what is the use of friend function? : Sql dba

1058

---

What is join view in sql?

988

---

What is lookup table in sql?

1091

---

Is and as keyword in pl sql?

1012

---

How global cursor can be declare with dynamic trigger ?

2270

---

What is the use of procedures?

1015

---