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 ?
- 2 Answers
- 4164 Views
- I also Faced
- E-Mail Answers
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
How to start instance with a minimal initialization parameter file?
How to define an explicit cursor in oracle?
What are the extensions used by oracle reports?
Oracle
How to use subqueries with the in operator using oracle?
How a database is related to tablespaces?
What is tns service name?
How many categories of data types?
Explain about your project and its relation to the current job position you are applying to?
How can windows applications connect to oracle servers?
How to convert character types to numeric types?
What is an oracle database table?
Explain a segment?
What is an Oracle Instance?
What is an oracle user role?
