Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4505 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
What is an external table?
What are the most common interview questions on ETL Testing for experience?
 How to use an oracle sequence generator in a mapping?
What is backup in Oracle?
How do you tell what your machine name is and what is its IP address?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How can windows applications connect to oracle servers?
How to get the Installed Oracle Version Information ?
How to synchronize 2 schema's objects?
How to select some columns from a table in oracle?
What are dml statements in oracle?
How to shutdown your 10g xe server?
what are actual and formal parameters?
How to define a variable to match a table column data type?
How many types of auditing in Oracle?
