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 |
Which is better trigger or stored procedure?
How to write pl sql program in mysql command prompt?
what is commit? : Sql dba
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
If we have n no of columns in a table, can we add new column in that table with not null constraint?
how to create a primary key with out creating an index?
How to run sql statements through the web interface?
Why cross join is used?
How do you write an index?
What is using in sql?
Describe types of sql statements?
Can we debug stored procedure?