On Fri, 5 Mar 1999, Dhaval Rasania wrote:
> Sir,
> I am having a great problem . I am using D2K 2.0 as my development tool
> and Oracle 8.0 as back end tool. I am developing Bank accounting
> Reconciliation
> System, I have desinged forms 5.0 modules for all functions in the
> system.
> The problem is that, in the form modules, Forms5.0 allows me to link a
> table
> to the Data Block at design time only, but I want to maintain seperate
> table
> for each month transactions. i.e all Credit Transactions for April
> should be
> entered in a table called CRED_9904, where 9904 is the text item in a
> entry form, based on this text item, I created a table CRED_9904 using
> FORMS_DDL built in, but the problem is that forms gives an error while
> Inserting data in to this table. i.e
> Insert into Table_name... where table_name is a string containing
> CRED_9904.
> The same problem I encountered while Selecting data.
> Select * from Table_name, here it do not allow a  string of table name.
> I request your goodself to assist in this matter.
> Also suggest, is it a right way to manupulate data for each month..?
> If not suggest the best possible way, so that I can maintain
> transactions of
> each month in a seperate table.
> Thanks in Advance
> Dhaval C Rasania
> dc_rasania@yahoo.com
> dc_rasania@hotmail.com

The best way to store different months in different "tables" is to use a
partitioned table. You can define each partition on a different month.
Oracle will automatically store the data in the appropriate partition
based on the month with no change to your forms.

For example, if you insert a record for July 1999, it will get stored in
the July1999 partition. When you select data, Oracle automatically knows
which partition to look at. You just supply the overall table name.

The other plusses are that you can have separate INITAL/NEXT/PCTUSED/etc
storage parameters for each partition. You can bring up and down
partitions at will. You can store partitions on separate tablespaces, and
with different statistics.

The only downside is that you have to create the partition and write the
SQL (which is trickier than a CREATE TABLE, but worth it in your case).

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 265+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page t="18"> Back to Ari Kaplan's Home Page