Pass dynamic parameters to a Materialized View
460718Jan 30 2007 — edited Jan 30 2007Hi all,
Is it possible to pass parameters to a materialized view(MV)?
Example: The sql query in the MV should be able to dynamic
-------------------------------------------------------
select * from a table where load_date = '01/30/2007'
-------------------------------------------------------
I need to pass in the load_date dynamically, each day.
I could use TRUNC(SYSDATE) but I would require to use some other date if i have had failures a week ago.
Actual requirement
----------------------------
I thought MV would be a good match, but got into a fix as I had to pass parameters dynamically.
Rather than confusing everyone with my ideas, I put forward my situation -
Store the results of a query (which joins tables with 200 million and 500 million rows, and make use the results in further processing.(Further group on them)
Any other suggestions other than using MV ?
Let me know if you need more information, or if was not clear
Experts, any sugestions?
Thanks
Narasimha Kade