dynamic querying
I have a Table containing product info
we then use a product_ID as a prefix on other tables in which we collect stocking levels/buying activities etc
I now need a way of iterating over these abc_ProdType1 tables so that I can extract data for marketing reports etc
I am thinking along the lines of a function/procedure which should iterate across the list of product_ID (I can get this from a simple select query)
2nd query needs to construct the select query abc_ProdType1 tables by building the table name dynamically incorporating the product_ID
The results of this query then get Insert into my mktg_Table
Does this sound like a reasonable way of tackling my problem
If so can you give some hints as to how I construct this
any help greatly appreciated
transuaranics
Subject
Written By
Posted
dynamic querying
February 15, 2013 11:35AM
February 20, 2013 05:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.