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
15367 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 benefit of foreign key?

960

what are the advantages of mysql in comparison to oracle? : Sql dba

939

What is a trigger in sql?

1157

What is a database event trigger?

1081

What is dba in sql? : SQL DBA

997

When to use inner join and left join?

903

How many parts of a pl sql block are optional?

1032

State some properties of relational databases?

1001

What is the use of triggers?

979

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

931

What is the difference between the sql*loader and import utilities? : aql loader

976

what is oracle database ? : Sql dba

967

who introduced sql?

948

Is full outer join same as cross join?

913

Can a primary key be a foreign key?

969