Answer Posted / satish asnani
Answer from Santosh Kumar is correct with slight
improvement. The simple views are actually called Updateable
Views and Complex views are called Non-Updateable Views.
Updateable means we can perform DML operations(Insert,
Update & Delete) on such views. Non-Updateable means we
cannot perform DML operations.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do you use join?
How do I run a sql query?
How many sql databases can you have on one server?
What is a behavioral trigger?
What is set serveroutput on?
How does one load ebcdic data? : aql loader
What is the maximum rows in csv?
What are the rules to be applied to nulls whilst doing comparisons?
what is blob? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the uses of merge?
What is an example of translating a date into julian format?
how to get a list of indexes of an existing table? : Sql dba
Does truncate require commit?
What is the sql query to display the current date?