what are views?

Answer Posted / annu rajput

View is a logical subset of the data.

it is not a physical storage for the data

it hides the logic through base table created.

it restrict the access to the data.

even it can make data readable.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to divide query output into groups in oracle?

565


How to execute a stored program unit?

587


How to use existing values in update statements using oracle?

550


What privilege is needed for a user to connect to oracle server?

565


How to export data with a field delimiter?

585






What do you mean by merge in oracle and how can you merge two tables?

530


What is the difference between a primary key & a unique key?

593


Explain about integrity constraint?

612


how to make an oracle object

1862


what is difference between sql plus and sql*plus? (not sql and sql plus).

3355


Why do we use bulk collect in oracle?

575


Can group functions be used in the order by clause in oracle?

584


How to retrieve data from an explicit cursor?

565


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1464


Explain the use of record option in exp command.

543