can we delete the trigger in a view? if yes why if not why?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / gouri sankar

5 Answers
15366 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we delete the trigger in a view? if yes why if not why?..

Answer / 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 This Answer Correct ?

11 Yes

0 No

can we delete the trigger in a view? if yes why if not why?..

Answer / sam

no we cannot delete trigger on a view.

Is This Answer Correct ?

12 Yes

7 No

can we delete the trigger in a view? if yes why if not why?..

Answer / kishore

create or replace
TRIGGER VIEW_TIG
INSTEAD OF INSERT OR DELETE OR UPDATE ON TEST_VIEW
BEGIN
NULL
END

1 create or replace
2 TRIGGER VIEW_TIG
3 INSTEAD OF INSERT OR DELETE OR UPDATE ON TEST_VIEW
4 BEGIN
5 NULL;
6* END;
SQL> /

Trigger created.

SQL> DROP TRIGGER VIEW_TIG;

Trigger dropped.

Is This Answer Correct ?

2 Yes

0 No

can we delete the trigger in a view? if yes why if not why?..

Answer / deep

YES OFFCOURSE ... WE CAN DELETE THE TRIGGER VIEW AS USING DROP COMMAND. IN ORDER TO DROP ANY TRIGGER

DROP TRIGGER TRIGGER_NAME;

TIGGER DROPPED.....

Is This Answer Correct ?

1 Yes

0 No

can we delete the trigger in a view? if yes why if not why?..

Answer / shashi bhusan

Is This Answer Correct ?

1 Yes

1 No

Post New Answer