If we update a complex view, is base table will get update ?
Answer Posted / dinesh
Yes We can update base table through complex view
Using "Instead of trigger"
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Why stored procedures are faster than query?
How many row comparison operators are used while working with a subquery?
what is cross join? : Sql dba
Why stored procedure is better than query?
what is myisam? : Sql dba
What are the subsets of sql?
Which are the different character-manipulation functions in sql?
What is a sql*loader control file?
How do I filter in sql profiler?
Does normalization improve performance?
Does a user_objects view have an entry for a trigger?
What type of join is sql join?
Which is better join or subquery?
How do you update a value in sql?
How do I find duplicates in a single column in sql?