Answer Posted / kishore

create or replace
TRIGGER VIEW_TIG
INSTEAD OF INSERT OR DELETE OR UPDATE ON TEST_VIEW
BEGIN
NULL
END

1 create or replace
2 TRIGGER VIEW_TIG
3 INSTEAD OF INSERT OR DELETE OR UPDATE ON TEST_VIEW
4 BEGIN
5 NULL;
6* END;
SQL> /

Trigger created.

SQL> DROP TRIGGER VIEW_TIG;

Trigger dropped.

What is composite data type in pl sql?

547

---

How would you reference column values before and after you have inserted and deleted triggers?

616

---

How to get help at the sql prompt?

630

---

Whis is not false in primary key?

966

---

how to present a past time in hours, minutes and seconds? : Sql dba

549

---

---

What are inner outer left and right joins in sql?

503

---

Does sql profiler affect performance?

547

---

What does sql stand for?

536

---

What is sql query optimization?

535

---

Can we insert in view in sql?

554

---

Differentiate between syntax and runtime errors.

631

---

What is sql stand for?

567

---

What is update query?

539

---

How to place comments in pl/sql?

595

---

what happens if null values are involved in expressions? : Sql dba

557

---