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 pl sql quora?

1085

---

What are the topics in pl sql?

940

---

What is the difference between clustered and non-clustered indexes?

1035

---

What is compound trigger?

975

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1055

---

Explain the types of joins in sql?

976

---

Define the select into statement.

1002

---

What is the plv (pl/vision) package offers?

991

---

Can we use loop in sql?

939

---

Can a procedure in a package be overloaded?

996

---

How do I count rows in sql?

960

---

what is a unique key ? : Sql dba

1047

---

what is commit? : Sql dba

1036

---

What are the different datatypes available in PL/SQL?

1042

---

What are the types of views in sql?

1053

---