Talk about views

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


Please Help Members By Posting Answers For Below Questions

What are the types of variable use in pl sql?

557


Why functions are used in sql?

506


What type of database is sql?

609


Is stored procedure faster than query?

555


What are two statement types in sql?

531






Can you load data into multiple tables at once? : aql loader

593


How do I create a sql script?

529


What are the properties of a transaction?

548


What found sql?

516


What is a join query?

539


How do I count rows in sql query?

482


What is clustered index in sql?

580


How do I make my sql query run faster?

456


What is the usage of when clause in trigger?

561


Why do we need pl sql?

538