OraFAQ Forum: SQL & PL/SQL » Creating ORACLE VIEW in a VIEW

Home » SQL & PL/SQL » SQL & PL/SQL » Creating ORACLE VIEW in a VIEW

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating ORACLE VIEW in a VIEW [message #19686]

Wed, 03 April 2002 14:48

vp
Messages: 25
Registered: January 2002

Junior Member

Hi ,

Can I create a VIEW in a VIEW in ORACLE?

Thanks,
VP

Report message to a moderator

Re: Creating ORACLE VIEW in a VIEW [message #19700 is a reply to message #19686]

Thu, 04 April 2002 04:41

John R
Messages: 156
Registered: March 2000

Senior Member

Depends on what you mean by 'in a VIEW' really.
You can create a view which is based on a view as well as on other tables.

Report message to a moderator

Re: Creating ORACLE VIEW in a VIEW [message #19708 is a reply to message #19700]

Thu, 04 April 2002 08:21

vp
Messages: 25
Registered: January 2002

Junior Member

thanks John!

Report message to a moderator

Re: Creating ORACLE VIEW in a VIEW [message #20540 is a reply to message #19686]

Mon, 03 June 2002 10:47

Kenan Bektas
Messages: 2
Registered: June 2002

Junior Member

Yes, you can.
Because the views are database objects, you can use them for some other queries. However, make sure that the related views exist prior to new creation.

Cheers,

-Kenan Bektas
DBA

Report message to a moderator

Previous Topic:	Re: Find Numbers
Next Topic:	URGENT help on a TRIGGER PLEASE!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 14:01:51 CDT 2024