how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
Answer Posted / monika
by creating instead of trigger on table,we can update base
table through view
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you define a foreign key?
What is rownum in sql?
what is auto increment? : Sql dba
Explain table and field in sql?
What are functions in sql?
How to add a column ‘salary’ to a table employee_details?
What is sql keyword?
What is the sql*loader? : aql loader
What is cte sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Can there be 2 primary keys in a table?
How to avoid duplicate records in a query?
Why is sql*loader direct path so fast?
What is the difference between having and a where in sql?
Who is the owner of mysql database?