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
- 4654 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 do I limit the number of rows returned by an oracle query after ordering?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to convert times to characters in oracle?
How to import one table back from a dump file?
What is hot backup and logical backup?
How to update values in a table in oracle?
How to write numeric literals in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is the implicit cursor in oracle?
How to set up autotrace for a user account?
How to create tables for odbc connection testing?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the usage of analyze command in oracle?
Explain the use of consistent option in exp command.
How do I connect to oracle database?
