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
- 4506 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / abhisudipta
Yes, Mr. Karthik, u r very correct. But still I am going to
focus one another point is that Oracle corp. says the
objects are those which has the physical existence as well
as is applicable to any user interface application, there a
object is being used but non object is not being used.
Say for example directory is the non-object of the oracle so
we can't use directly through any application coding.
From: Sudipta Santra(+91-8951011605)
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a system tablespace and when it is created?
What is difference between a formal and an actual parameter?
How to turn on or off recycle bin for the instance?
how do u setup a replication site?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
How can we find the size of a database?
Can you tell me how to add new column in existing views?how?How is possible?
How you find out version of installed workflow?
How many types of segments in Oracle?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
what is meant by magic query
How to get the Installed Oracle Version Information ?
Oracle General 
