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
15548 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 t sql in sql server?

1063

How can you get sql*loader to commit only at the end of the load file? : aql loader

1003

what is a stored procedure? : Sql dba

1121

Explain spool.

1172

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

1006

Explain autonomous transaction.

1152

What is input buffer in sql*plus?

1207

What is cursor explain with example?

973

How to start oracle sql developer?

1023

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

What is auto increment feature in sql?

1116

What are functions in sql?

948

What are commit, rollback, and savepoint?

982

What is sql prepared statement?

976

How delete all data from table in sql?

1011