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 is a process of pl/sql compiled?
what is a table in a database ? : Sql dba
What is normalization sql?
What is the difference between inner join and left join?
What is the difference between a primary key and a unique key?
what is the use of friend function? : Sql dba
How do I view a table in sql?
Why trigger is used in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is the difference among union, minus and intersect?
What is the difference between microsoft sql and mysql?
What is the best sql course?
what is “go” in t-sql? : Transact sql
What are different categories of sql commands?
What are different methods to trace the pl/sql code?