Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain oracle left join with an example?
what is the scenario where you take the database to NoArchivelog mode?
How do I connect to oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
What are the predefined tablespaces in a database?
Does oracle database need java?
What is analyze command used for?
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'));
How can we create the complete backup of data in the oracle.
what are the default admin accounts in Oracle 10g ?
Explain the use of indexes option in exp command.
What happens if you lost a data file?
Explain overloading. Can functions be overloaded?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is using clause and give example?
