Answer Posted / ab
View do not contain data.
when u query view it featches the data from the underlaying
table on which view is created.
v$ views are created in X$ base tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to retrieve data from an cursor to a record?
How to define a record variable to store a table row?
How to check the oracle tns settings?
How to use "for" statements in oracle?
How to update values in a table in oracle?
What do you understand by a database object? Can you list a few of them?
definition of cluster and non-clustered index?
what is the use of system.effective.date variable in oracle?
How do I learn what codesets are available in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What privilege is needed for a user to insert rows to tables in another schema?
Explain the difference between a procedure and a function?
How can we find out the current date and time in oracle?
Is there a function to split a string in plsql?
Can we create trigger on materialized view in oracle?