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 difference between inner join and cross join?

1019

---

Where is pl sql used?

1004

---

What does where 1/2 mean in sql?

1144

---

How can you fetch common records from two tables?

1103

---

How is data stored in sql?

1101

---

What is t-sql? : Transact sql

1041

---

What is the difference between microsoft access and sql server?

1106

---

What is the difference between having clause and where clause?

1112

---

What is cursor and its types?

1151

---

What are sql ddl commands?

1136

---

What is a string data type in sql?

1100

---

What is the difference between cluster and non-cluster index?

1157

---

Is sql a case sensitive language?

1010

---

what is an extent ? : Sql dba

1159

---

List out the acid properties and explain?

1018

---