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 bulk compiling in pl/sql.?

1130

---

What is the difference between row level and statement level trigger?

1022

---

Inline the values in PL/SQL, what does it mean.?

1229

---

What is dense_rank in sql?

986

---

explain the difference between myisam static and myisam dynamic. : Sql dba

945

---

What is the process of copying data from table a to table b?

1093

---

What are the two types of periodical indexes?

940

---

What is sorting in sql?

949

---

What found sql?

945

---

Is a foreign key always unique?

943

---

How can you load microsoft excel data into oracle? : aql loader

1174

---

Is sql a backend language?

1096

---

What is user in sql?

1025

---

define sql insert statement ? : Sql dba

1031

---

What is an alias command?

1069

---