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
- 3668 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to create id with auto_increment on oracle?
What is oracle database 10g express edition?
How to do paging with oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain the use of record option in exp command.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Can a formula column referred to columns in higher group ?
What is an anonymous block?
Who developed oracle & when?
What are the different editions of oracle?
What is the difference between $oracle_base and $oracle_home?
What are a query and state the different types of queries and their uses?
