Oracle Views

Hi Experts,

Can you create a Oracle View From a View in Oracle as you can in SQL Server? If so, How?
December2000Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Yes.

Just issue the create view syntax just like you always do.

create or replace view myview1 as select * from dual;

create or replace view myview2 as select * from myview1;
0
 
DavidSenior Oracle Database AdministratorCommented:
0
 
slightwv (䄆 Netminder) Commented:
>>This was answered a year ago

That quetion was how to retrieve the view SQL.   Unless I'm missng something, this one is how to create a view.
0
 
December2000Author Commented:
You rock, thank you! :o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here