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
- 4667 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 |
Difference between pre-select and pre-query
What are the varoius components of physical database structure of oracle database?
How to use select statement to count the number of rows in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
Can group functions be used in the order by clause in oracle?
what are the disadvantages of hierarchial database over RDBMS?
What is the difference between substr and instr?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
What is TNS File
how can we store any pdf file in oracle
Oracle General 
