Re: How do i make this Stored Procedure worl well?
There's no way for someone without your tables to debug an sproc like this.
What is it about the problem you are solving that you think requires a new table per day of data!?
It would be much more efficient to have a calendar table with a row for each desired date, and formulate your queries using those dates as joins from that table.
Calls to PREPARE and EXECUTE must be followed by a call to DROP PREPARE.
Subject
Views
Written By
Posted
1858
April 11, 2013 01:53PM
Re: How do i make this Stored Procedure worl well?
995
April 12, 2013 12:00AM
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.