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

Can we use rowid as primary key?

547

---

what is top in tsql? : Transact sql

547

---

Is not null in sql?

560

---

what are the differences between require and include, include_once and require_once? : Sql dba

532

---

What is linq to sql?

554

---

---

What is varchar used for?

536

---

What is dynamic query?

542

---

Are views faster than queries?

548

---

How do I pipe the output of one isql to another?

532

---

What is the difference between left outer join and left join?

517

---

What is inner join in sql?

586

---

What do you mean by stored procedures? How do we use it?

525

---

what are string data types? : Sql dba

514

---

what is schema? : Sql dba

562

---

What is the difference between microsoft sql and mysql?

512

---