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
- 4118 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 the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How many memory layers are in the oracle shared pool?
What is oracle host variable?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is object data modeling?
Please explain drop constraint oracle?
How many types of database triggers exist?
What are the built-in functions used for sending Parameters to forms ?
Explain the use of file option in exp command.
How to create additional tablespaces for an new database?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to rebuild an index in oracle?
What operating systems are supported by oracle database 10g xe?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What are internal user account in oracle?
