create or replace TRIGGER VIEW_TIG INSTEAD OF INSERT OR DELETE OR

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

Question Posted / kishore

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between a local and a global temporary table? : Sql dba

1127

what is bdb (berkeleydb)? : Sql dba

1091

what is datawarehouse? : Sql dba

1066

Is coalesce faster than isnull?

1017

What is a sql select statement?

1082

Which certification is best for sql?

1040

What are the most important ddl statements in sql?

1186

What is java sql driver?

1182

What is basic structure of pl sql?

1130

Is it possible to create startup or shutdown trigger for on-schema?

1091

What is embedded sql with example?

1097

What does the acronym acid stand for in database management?

1088

List and explain the different types of join clauses supported in ansi-standard sql?

1401

Does view store data in sql?

1042

Which are the different case manipulation functions in sql?

1076