dynamic querying
Posted by: Stefan Maric
Date: February 15, 2013 11:35AM

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

Options: ReplyQuote


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.