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

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 all the common sql function? : Sql dba

573


what is the difference between truncate and delete statement? : Transact sql

531


What is normalization in a database?

600


What is structural independence and why is it important?

539


What does the file extension accdb stand for?

541






what is online transaction processing (oltp)? : Sql dba

520


What are the advantages of pl sql over sql?

535


How do you use a while loop in pl sql?

528


How can we solve sql error: ora-00904: invalid identifier?

689


What are basic techniques of indexing?

835


What is natural join in sql?

528


What is execute immediate?

540


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

557


what is transaction? : Sql dba

521


What operators deal with null?

599