Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

Oracle Views

Hi Experts,

Can you create a Oracle View From a View in Oracle as you can in SQL Server? If so, How?
0
December2000
Asked:
December2000
Advertise Here
  • 2
2 Solutions
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Go Premium
  • 2
Advertise Here
Tackle projects and never again get stuck behind a technical roadblock.
Join Now