OraFAQ Forum: SQL & PL/SQL » Create View from Dynamic Query (or Function Returning Query)

Home » SQL & PL/SQL » SQL & PL/SQL » Create View from Dynamic Query (or Function Returning Query) (Oracle 10g, Linux(RedHat))

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

Create View from Dynamic Query (or Function Returning Query) [message #572055]

Wed, 05 December 2012 11:19

greendba
Messages: 22
Registered: September 2008
Location: Toronto

Junior Member

I have a dynamic query stored in a function that returns a customized SQL statement depending on the environment it is running in.
I would like to create a Materialized View that uses this dynamic query.
I'm at a loss as to how to approach this.

Thanks,
Eric

Report message to a moderator

Re: Create View from Dynamic Query (or Function Returning Query) [message #572056 is a reply to message #572055]

Wed, 05 December 2012 11:24

BlackSwan
Messages: 20097
Registered: January 2009

Senior Member

objects constructed using dynamic SQL can only be accessed using dynamic SQL; which results in non-scalable application

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Wed, 05 December 2012 11:24]

Report message to a moderator

Previous Topic:	TYPE NUM_ARRAY as table of number
Next Topic:	regexp_substr Ending with Number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 16:21:34 CDT 2013

Total time taken to generate the page: 0.84651 seconds