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
Explain the difference between 'between' & 'and' operators in sql
what is row? : Sql dba
Which sorts rows in sql?
what is a trigger in mysql? : Sql dba
How do you declare a constant?
Does oracle roll back the transaction on an error?
What is the difference between row level and statement level trigger?
What is lexical units in pl sql?
What is prepared statement in sql?
What is the difference between union and union all command?
what is error ora-03113: end-of-file on communication channel?
What is the use of count (*) in sql?
Which table is left in left join?
What view means?
How does a self join work?