Answer Posted / vijay kumar s

Hi all,

leave th 9th answer ............

ignore 9 th answer....

see below one

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(101);
INSERT INTO T_CHK VALUES(101)
*
ERROR at line 1:
ORA-20011: VALUES SHOULD BE < 100
ORA-06512: at "SVR.CHKT", line 3
ORA-04088: error during execution of trigger 'SVR.CHKT'




Trigger will fire Before insert trigger only
then constraints
then after insert trigger

what is union? : Sql dba

1028

---

what is denormalization. : Sql dba

1113

---

Why use stored procedures?

1094

---

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

1061

---

Write an sql query to select all records from the table?

1030

---

what is msql? : Sql dba

989

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

---

How to load data with sql*loader?

1051

---

what is recursive stored procedure? : Sql dba

987

---

What is the difference between union and union all command?

1091

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

What is a variable in sql?

1002

---

what is a constraint? : Sql dba

1173

---

What is the difference between sql and mysql?

1118

---

How to sort the rows in sql.

1076

---