Hello when I use the following SQL statement (SELECT (TO_DATE (SYSDATE - 200 + LEVEL, 'DD-MON-RRRR')) date_range FROM DUAL CONNECT BY LEVEL <= 1000)temp_tab
It will compile, but will not return any row at run time. Do you have any suggestions for me?
Hi Kendell, I just tried following query in my DB and it produced all 1000 rows for me. == SELECT (TO_DATE (SYSDATE - 200 + LEVEL, 'DD-MON-RRRR')) date_range FROM DUAL CONNECT BY LEVEL <= 1000 == Do you see any kind of error or a message when you run this. ?
2 comments:
Hello when I use the following SQL statement (SELECT (TO_DATE (SYSDATE - 200 + LEVEL, 'DD-MON-RRRR')) date_range FROM DUAL CONNECT BY LEVEL <= 1000)temp_tab
It will compile, but will not return any row at run time. Do you have any suggestions for me?
Hi Kendell,
I just tried following query in my DB and it produced all 1000 rows for me.
==
SELECT (TO_DATE (SYSDATE - 200 + LEVEL, 'DD-MON-RRRR')) date_range FROM DUAL CONNECT BY LEVEL <= 1000
==
Do you see any kind of error or a message when you run this. ?
Post a Comment