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.

How do I view tables in sql developer?

934

---

what is a database transaction? : Sql dba

1169

---

How do I make sql search faster?

990

---

explain the advantages and disadvantages of stored procedure? : Sql dba

1005

---

What is sql in java?

1074

---

What is the usage of sql functions?

1144

---

How you improve the performance of sql*loader? : aql loader

1009

---

what is clause? : Sql dba

1057

---

What is clustered and nonclustered index in sql?

938

---

Can we insert in view in sql?

1049

---

What is the difference between view and stored procedure?

959

---

How do you bind variables in pl sql?

1088

---

Write a sql query to convert all character to uppercase after hypen.

1433

---

How many triggers can be applied on a table?

930

---

what is the difference between delete and truncate statement in sql? : Sql dba

1234

---