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
- 4747 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 use "if" statements on multiple conditions?
Explain the use of consistent option in exp command.
How to convert numbers to characters in oracle?
What is the use of file param in imp command?
What is oracle analytical function?
How to write text literals in oracle?
How can you use check constraints for self referential integrity?
What are ddl statements in oracle?
What is the difference between a user and a schema in oracle?
What happens in oracle commit?
List out the types of joins.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the various types of snapshots ?
How to load excel data sheet to oracle database
What is translate in oracle?
