what are views?

Answer Posted / harsha vardhan reddy

1.It is a LOGICAL and VIRTUAL object.

2.It is stored select statement.

3.It allows DESCRIBE,DML,SELECT on it.

4.It will not hold data in it.

5.It supports to share "selected rows and columns with
other user"

6.It provides security while sharing.


regards,
harsha518@gmail.com
harsha.vardhan@cmcltd.com

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write date and time interval literals in oracle?

575


Point out the difference between user tables and data dictionary?

546


How will you identify oracle database software release?

527


How to shutdown your 10g xe server?

618


What is a schema in oracle?

548






How to set a transaction to be read only in oracle?

582


Explain drop constraint oracle?

593


What is merge in oracle?

561


How to bring a tablespace online?

522


Explain what are synonyms used for?

610


What is the purpose of tables, private synonyms and public synonyms in Oracle?

591


How to rename an existing table?

611


query optmization techniques and quwry analyser+projects+ppts

1932


How to write a query with a right outer join in oracle?

617


What is a package in oracle?

566