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
what are the type of locks ? : Sql dba
What is pl sql and why it is used for?
What is sql*loader and what is it used for?
How do I kill a query in postgresql?
Is pl sql better than sql?
What is anonymous block in sql?
What will you get by the cursor attribute sql%found?
Can a primary key be a foreign key?
What is percent sign in sql?
What is union?
how would concatenate strings in mysql? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is the difference between delete and truncate commands?
Can we use commit inside a trigger?
What are literals in sql server?