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 ?
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
How to start an oracle instance?
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....
How to rename a column in an existing table?
what is Single Byte Overhead...?
Explain the use of tables option in exp command.
How to check the oracle tns settings?
What is format trigger?
Query to retrieve record for a many to many relationship ?
how to join query for one source type is oracle another source type is sql server ?
Can we save images in a database and if yes, how?
How is it different from a normal table?
What do you understand by a database object?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Difference between pre-select and pre-query
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.