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.

Is ms sql is free?

955

---

Can we call a function containing dml statements in a select query?

917

---

Which command is used to delete a package?

1090

---

Does truncate need commit?

893

---

how is myisam table stored? : Sql dba

997

---

Why we use pl sql?

907

---

How to use boolean type in select statement?

994

---

How do you delete a table?

997

---

Why do we use function in pl sql?

1006

---

What is the use of %rowtype?

976

---

What does cursor do in sql?

970

---

List different type of expressions with the example.

893

---

What is nvarchar max in sql?

959

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

884

---

Explain the commit statement.

1102

---