YES OFFCOURSE ... WE CAN DELETE THE TRIGGER VIEW AS USING DROP COMMAND. IN

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

Question Posted / deep

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the 3 types of behavioral triggers?

1246

What does (*) mean in sql?

945

How would you pass hints to the sql processor?

978

how to use in conditions? : Sql dba

1009

Explain unique key in sql.

1003

What is exit statement?

1009

What is triggering circuit?

1062

Can we call procedure in select statement?

1049

differentiate between float and double. : Sql dba

1051

What is the starting oracle error number?

1050

What are field types?

996

how to select unique records from a table? : Sql dba

1106

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2490

What is the difference between nested table and varray?

997

What is server name sql?

1138