can we delete the trigger in a view? if yes why if not why?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how many columns can be used for creating index? : Sql dba
What is a transaction?
what are the limitations of identity column? : Transact sql
What is the diffrence between IN and EXISTS.which one is faster.
..........refers to the disk mirroring
define sql update statement ? : Sql dba
What is the difference between left join and right join?
What is procedure and function?
Can we create foreign key without primary key?
Can one improve the performance of sql*loader? : aql loader
How to start the command-line sql*plus?
What is Difference Between delete and Truncate?