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
Are subqueries better than joins?
Which one is faster ienumerable or iqueryable?
What is the difference between having clause and where clause?
how to write date and time literals? : Sql dba
What is difference between function and trigger?
How do we use distinct statement? What is its use?
When should I use nosql database?
Which command is used to call a stored procedure?
What is a recursive join sql?
What are the types of keys?
What is scope of pl sql developer in future?
How does postgresql compare to oracle/db2/ms sql server/informix?
How do you clear the screen in sql?
What is loop in pl sql?
Is mariadb nosql?