According to oracle specification VIEW is a object.
OBJECT that means anything stored in the oracle database
that has the physical existence.why VIEW doesn't take memory
in oracle database, but it is treated as a object ?Please
explain ?

Answer Posted / karthik perumal

A view is a SQL query which is stored in the Oracle data
dictionary.We can think of a view as a virtual table or
mapping of data from one or more tables.Since it is stored
in Oracle's Data Dictionary,it is treated by Oracle as an
Object.


Remember:Views do not contain any data - it is just a stored
query in the database that can be executed when called.

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 start instance with a minimal initialization parameter file?

806


How to define an explicit cursor in oracle?

810


What are the extensions used by oracle reports?

799


Oracle

2160


How to use subqueries with the in operator using oracle?

846


How a database is related to tablespaces?

792


What is tns service name?

859


How many categories of data types?

774


Explain about your project and its relation to the current job position you are applying to?

784


How can windows applications connect to oracle servers?

747


How to convert character types to numeric types?

801


What is an oracle database table?

793


Explain a segment?

835


What is an Oracle Instance?

901


What is an oracle user role?

799