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
Difference between open_form and call_form in oracle.
Is oracle the best database?
How to rename an index?
What is an oracle?
What is meant by joins?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
what is reindexing?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how to handle exceptions in post production
How would you begin to troubleshoot an ORA-3113 error?
How to update values in a table in oracle?
How to use values from other tables in update statements using oracle?
What are the oracle differences between nvl and coalesce
What is an oracle recycle bin?