Answer Posted / revathi
Yes, it is possible.
Ex:
create or replace view my_view_3 as
select mv1.id, mv1.name, mv1.address
from my_view_1 mv1.
mv1 IS A ANOTHER VIEW
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to get last row id?
Describe the types of sub query?
How to export data with a field delimiter?
What are the advantages of oracle?
What are nested tables?
Difference between open_form and call_form in oracle.
When do you get a .pll extension in oracle?
What is the difference between pre-select and pre-query?
Give the various exception types.
Give the advantages and disadvantages of clusters.
Explain what are the different type of segments?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to start a specific oracle instance?
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?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database