What is the relation b/w view and trigger

Answer Posted / vivekanandhan

view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we alter stored procedure?

545


What is an exception in pl/sql?

544


How do you declare a user-defined exception?

530


What are the uses of sysdate and user keywords?

631


What is right join in sql?

556






Can primary key be changed?

529


What is field delimiter?

637


Explain polymorphism in pl/sql.

641


how to enter binary numbers in sql statements? : Sql dba

493


Is ms sql is free?

533


Why left join is used in sql?

519


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

522


What is the non-clustered index in sql?

589


can sql servers linked to other servers like oracle? : Sql dba

554


What is a native sql query?

496