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
- 4108 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 |
Explain the use of constraints option in exp command.
What is a oracle database?
Can objects of the same schema reside in different tablespace?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Is it possible to disable the parameter from while running the report ?
create one table to capture an employee details with a primary key.
What is redo log?
What are named parameters?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Which database is better for os platform dependency?
What are the Limitations of a CHECK Constraint ?
How to manage transaction isolation level?
Oracle General 
