Home » SQL & PL/SQL » SQL & PL/SQL » Create View from Dynamic Query (or Function Returning Query) (Oracle 10g, Linux(RedHat))
Create View from Dynamic Query (or Function Returning Query) [message #572055] Wed, 05 December 2012 11:19 Go to next message
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
Re: Create View from Dynamic Query (or Function Returning Query) [message #572056 is a reply to message #572055] Wed, 05 December 2012 11:24 Go to previous message
BlackSwan
Messages: 23155
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:
  


Current Time: Sat Dec 20 16:02:32 CST 2014

Total time taken to generate the page: 0.07634 seconds