Answer Posted / nilesh
No , View Do not contain data, instead it contains the SQL
Statement Only.
When we issue statement as select * from <VIEWNAME>
it executes the query to get the rows from the underlying
table on which it is been created.
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
How can I introduce multiple conditions in like operator?
How to drop an existing view in oracle?
How to get a create statement for an existing table?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is system global area (sga) in oracle?
What is the difference between substr & instr functions?
What is the difference between 10g OEM and 11g OEM?
How do you tell what your machine name is and what is its IP address?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is the difference between sharding and replication?
Differentiate between pre-select and pre-query?
Explain constraining triggers.
How to join two tables in a single query using oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to pass a parameter to a cursor in oracle?