Re: dynamic querying
Posted by:
Rick James
Date: February 20, 2013 05:17PM
It is usually poor design to have lots of 'identical' tables.
In a Stored Procedure, you can use CONCAT, PREPARE, EXECUTE, and DEALLOCATE to construct a query, then perform it.
You can use a query on information_schema.TABLES to dynamically discover the desired table names.
Subject
Written By
Posted
February 15, 2013 11:35AM
Re: dynamic querying
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.