SQL

Seite 1

VIEWS:

To make complex query into simple.

insert update delete can happen in base table WITH READ ONLY

INSERT operation if u handle with check option.if where clause have not null..insert never allows null values

YES, you can Update and Insert into view and that edit will be reflected on the original table....

Question: Can you update the data in an Oracle VIEW?

Answer: A VIEW in Oracle is created by joining one or more tables.

When you update record(s) in a VIEW, it updates the records in the underlying tables that make up the View.

So, yes, you can update the data in an Oracle VIEW providing you have the proper privileges to the underlying Oracle tables.

Question: Does the Oracle View exist if the table is dropped from the database?

Answer: Yes, in Oracle, the VIEW continues to exist even after one of the tables (that the Oracle VIEW is based on) is dropped from the database. However, if you try to query the Oracle VIEW after the table has been dropped, you will receive a message indicating that the Oracle VIEW has errors.

https://www.techonthenet.com/oracle/views.php

Seite 2