Re: generate list of days of curr month in SQLPLUS

From: <nasof_at_hotmail.com>
Date: Wed, 02 Sep 1998 17:14:11 GMT
Message-ID: <6sjud3$5v$1@nnrp1.dejanews.com>

Try:

SELECT rownum day
FROM all_objects
WHERE rownum between 1 and to_number(to_char(last_day('1-AUG-98'),'DD'))

In article <35EC7E7A.617A7947_at_cisco.com>, Kal Khatib <kkhatib_at_cisco.com> wrote:
> is it possible to write a statement that returns
> number_of_days_in_curr_month rows, each row containing the day,
> in SQLPLUS?
>
> example:
>
> day
> -----
> 1
> 2
> 3
> ...
> ...
> 31
>
> thanks
> Kal.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 12:14:11 CDT