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


Please Help Members By Posting Answers For Below Questions

How to create an initialization parameter file?

543


Explain an exception?

568


Which are the five query types available in oracle?

532


How to assign values to data fields in record variables?

584


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2050






What are the ansi data types supported in oracle?

521


what is normalisation?what are its uses?

1763


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1807


What is snapshot is too old? Give and example for better understand.

1100


List out the types of joins.

595


How to download oracle database 10g xe?

600


How to export your connection information to a file?

598


How to create a table interactively?

562


Is insert autocommit in oracle?

606


What is primefaces used for?

559