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 serial sql?

975

---

describe transaction-safe table types in mysql : sql dba

1006

---

What is the non-clustered index in sql?

1064

---

How is data stored in sql?

1059

---

What is dcl in sql?

960

---

How is use pl and sql?

1061

---

Can we write dml inside a function in sql server?

949

---

What is pivot query?

1071

---

What is recursive stored procedure?

1099

---

how do you tune the slow running queries in oracle db , explain the methodology

2786

---

How many sql statements are used? Define them.

1038

---

what is 'mysqld'? : Sql dba

969

---

What is rename in sql?

973

---

What is on delete restrict?

1000

---

What is indexes?

1058

---