Answer Posted / pradeep

As per my knowledge we can drop trigger crated on view see
below exp

CREATE OR REPLACE FORCE VIEW "SCOTT"."TEST_VIEW"
("EMPNO", "ENAME", "JOB", "MGR", "HIREDATE", "SAL", "COMM",
"DEPTNO") AS
select "EMPNO", "ENAME", "JOB", "MGR", "HIREDATE", "SAL", "
COMM", "DEPTNO" from emp;

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

Trigger created.

SQL> drop trigger VIEW_TIG ;

Trigger dropped.

What is rownum?

530

---

What does rownum mean in sql?

545

---

Are left and right joins the same?

524

---

Is a table valued function object?

568

---

when is the use of update_statistics command? : Sql dba

494

---

---

what are the 'mysql' command line arguments? : Sql dba

641

---

how do you know the version of your mysql server? : Sql dba

498

---

What is sqlerrm?

536

---

What is plpgsql language?

523

---

If a cursor is open, how can we find in a pl/sql block?

665

---

Why triggers are used?

548

---

What is sql architecture?

553

---

What are the ddl commands?

527

---

What is 19 null in sql?

526

---

How many commands are in sql?

517

---