Re: table partitions

[Jay Hostetter]

Your high value for each partition can just be the beginning of every month.  For 
example:

CREATE TABLE ACCOUNTS
(
  STATEMENT_DATE                 DATE           NOT NULL,
  ACCOUNT_NUMBER                 VARCHAR2(8)    NOT NULL,
  BILLING_CYCLE                  VARCHAR2(2)    NOT NULL,