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 -> generate list of days of curr month in SQLPLUS

generate list of days of curr month in SQLPLUS

From: Kal Khatib <kkhatib_at_cisco.com>
Date: Tue, 01 Sep 1998 16:08:42 -0700
Message-ID: <35EC7E7A.617A7947@cisco.com>


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. Received on Tue Sep 01 1998 - 18:08:42 CDT

Original text of this message

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