Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Display of Dates

Display of Dates

From: radhika <rashika_18_at_hotmail.com>
Date: 12 Nov 2002 13:42:06 -0800
Message-ID: <5b8f3c02.0211121342.413ef8a4@posting.google.com>


Hi All,
Please help me with this query .

In table A , i have the following columns and records.

Inserted Date, Start_Date , End_Date, Qty

9/1/02, 10/01/02,    10/31/02, 30
9/2/02, 10/10/02,    10/20/02, 10
9/3/02, 10/1/02,     10/1/02 , 5
9/4/02, 10/1/02,     10/3/02, 7 

The user can only insert a startdate, end date and a qty he cannot update/delete records but can insert records if he changes his mind on the qty
the latest records overrides any previous records. So he came in on 9/1 and entered for the whole month then he kept changing his mind.
So
Now in the web app, i have to display the above dates in the following manner.

10/01/02 - 10/03/02 - 7
10/04/02 - 10/09/02 - 30 
10/10/02 - 10/20/02 - 10
10/21/02 - 10/31/02 - 30 

Peformancewise, please suggest a way to query the above table and display the data in the above manner

thanks Received on Tue Nov 12 2002 - 15:42:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US