Re: How to populate an LOV with SYSDATE, SYSDATE-1,etc.

Use this select statement and query from a table which has atlease 10 rows in it:

[Quoted] SELECT sysdate - rownum,

       sysdate - rownum
  FROM table1
 WHERE rownum < 11;

This should work.

Steve J.

Mark Hide wrote:
>
> Could anyone tell me what SQL I need to generate a record group that
> will consist of the ten dates leading up to today ?
>
> Can I do it with a simple query or do I have to use PL/SQL ?
>
> Thanks.
>
> --
> Mark Hide
Received on Mon Jul 07 1997 - 00:00:00 CEST