Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4533 Views
- I also Faced
- E-Mail Answers
Answer Posted / karthik perumal
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 |
Post New Answer View All Answers
What happens if you use a wrong connect identifier?
What is a snapshot log?
material view and view disadvantages?
How to sort the query output in oracle?
How to build data dictionary view an new database?
Can we create trigger on materialized view in oracle?
What is recovery manager in Oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What happens to the current transaction if a ddl statement is executed?
What is the relation of a user account and a schema in oracle?
How to convert a date to char in oracle? Give one example.
State the difference between a primary key and foreign key?
How to return top 5 rows in oracle?
What is difference between cartesian join and cross join?
Define oracle database
