Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Display of Dates
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
![]() |
![]() |