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.

Difference between global and parameter variables?

1453

---

what is bcp? When is it used?

578

---

What are stuff and replace function?

568

---

Is postgresql a nosql database?

532

---

What is difference between pls_integer and integer?

517

---

---

How to change the order of columns in Oracle SQL Plus ?

612

---

what is csv? : Sql dba

574

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

668

---

What is before and after trigger?

518

---

Which is faster count (*) or count 1?

540

---

How do I filter in sql profiler?

534

---

What is a sql profiler?

590

---

How does a self join work?

516

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

578

---

Why we use pl sql?

527

---