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

How does left join work in sql?

1012

---

Is sql an operating system?

1024

---

What sql database should I use?

1151

---

Why is stored procedure faster than query?

968

---

How do I write a cron which will run a sql query and mail the results to agroup?

992

---

Why procedure is used in sql?

1046

---

what are ddl statements in mysql? : Sql dba

1211

---

Write a query to display the current date in sql?

1033

---

Explain the purpose of %type and %rowtype data types?

940

---

How do you optimize a stored procedure query?

1005

---

What type of database is sql?

1033

---

Which sql statement is used to delete data from a database?

968

---

What is a trigger in sql?

1211

---

Why select is used in sql?

1026

---

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

1031

---