how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
Answer Posted / rajesh venati
If we create a view on more than one table, or using
distinct keyword or use any group functions it is called
complex view.
If we want perform DML operations on complex views the we
will go for Instead of Triggers.Through the instead of
triggers we can perform DML operations on complex views.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does bitemporal mean?
What is the use of primary key?
What is mutating table error?
What is rank function in sql?
What are different categories of sql commands?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is difference between cursor and trigger?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is union?
How do I sort a table in sql?
How do you exit in sql?
What is a loop in sql?
Does asenumerable execute the query?
how to rename an existing column in a table? : Sql dba
How many sql statements are used?