Monday, March 22, 2010
Query used to generate a date range in Value Sets or LOV
Below Query can be used to get the date range and widely used while creating LOV in Oracle Forms and Values Sets .
SELECT
(TO_DATE (SYSDATE - 1 + LEVEL, 'DD-MON-RRRR')) date_range
(TO_DATE (SYSDATE - 1 + LEVEL, 'DD-MON-RRRR')) date_range
, (TO_CHAR (SYSDATE - 1 + LEVEL, 'Month, DD RRRR')) date_word
FROM DUAL WHERE level > 1 CONNECT BY LEVEL <= 5
FROM DUAL WHERE level > 1 CONNECT BY LEVEL <= 5
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Query used to generate a date range in Value Sets or LOV”
Post a Comment