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 ?
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 |
How many types of tables are there in oracle?
What happens if you lost a data file?
How to best split csv strings in oracle 9i?
query optmization techniques and quwry analyser+projects+ppts
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What is blob data type in oracle?
What are the differences between number and binary_float in oracle?
How to load a large xml file?
What are a cluster and non-cluster index?
How to use "in" parameter properly?