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
How do I view a view in sql?
How can you know that statistics should be updated?
What is constant in pl sql?
What are sql*plus environment variables?
what are aggregate and scalar functions? : Sql dba
what is the difference between blob and text? : Sql dba
How many types of primary keys are there?
define join and explain different type of joins? : Sql dba
What is case function?
What is the difference between a subquery and a join?
What are keys in sql?
What packages(if any) has oracle provided for use by developers?
What type of database is sql?
What is input buffer in sql*plus?
Can we use pl sql in sql server?