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
Why do we use procedures in sql?
What is difference between sql and mysql?
Why do we use function in pl sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are the 3 modes of parameter?
What does joining a thread mean?
Show how functions and procedures are called in a pl/sql block.
What is the use of sql trace?
What is a table partition?
what is a materialized view? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Which is better join or inner query?
How do I remove duplicates in two columns?
What is left join in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?