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
15583 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

Should I use mbr or gpt?

1025

Is like operator in sql case sensitive?

1024

how is exception handling handled in mysql? : Sql dba

1080

Where do we use pl sql?

993

What does := mean in pl sql?

1042

what is the difference between blob and text? : Sql dba

1018

Is pl sql better than sql?

1031

Explain character-manipulation functions?

1132

Is sql procedural language?

967

What is loop in pl sql?

1037

what are the advantages of sql ? : Sql dba

1060

what are the different type of sql's statements ? : Sql dba

924

Why cross join is used?

1074

What is nvl?

1065

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060