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 are the different dcl commands in sql?

1075

---

Is drop table faster than truncate?

948

---

Which function is used to return remainder in a division operator in sql?

1080

---

How do I truncate a sql log file?

1018

---

Compare sql & pl/sql

1056

---

What is the least restrictive isolation level? : Transact sql

1005

---

What are crud methods?

978

---

how can we know the count/number of elements of an array? : Sql dba

1013

---

What are the syntax and use of the coalesce function?

1114

---

Which one is better subquery or joins?

1014

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1796

---

What is the difference between jpql and sql?

1030

---

How does sql developer connect to oracle database?

956

---

What is sql profiling in oracle?

1006

---

How do I clear the screen in sql plus?

987

---