what is view?

Answer Posted / jyoti ranjan samal

View is called vertual table which provides access to a sub
set of column when one or more table.
2.View can derived data one or more table.
3.It is a Query stored as an object of the database which
does not have own data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the relationship among database, tablespace and data file?

552


WHAT IS ecc 6.0

1671


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

661


How to retrieve data from an explicit cursor?

571


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4290






What is the difference between a user and a schema in oracle?

575


What privilege is needed for a user to delete rows from tables in another schema?

570


How to define an external table with a text file?

595


How to invoke the data pump export utility?

574


What is the maximum number of triggers that can be applied to a single table?

567


How to test null values?

687


can u plz provide me oca sql dumps please i need them

1480


What is ASM (Automatic Storage Management) in Oracle?

719


How to put more than 1000 values into an oracle in clause?

595


Which is faster join or subquery in oracle?

544