Query with CONNECT BY PRIOR [message #424030] |
Wed, 30 September 2009 00:20  |
lraok
Messages: 5 Registered: April 2009 Location: Bangalore
|
Junior Member |
|
|
Hi,
Can you please construct the query by using CONNECT BY PRIOR
Query:
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, ROWNUM -1), 'YYYY-MON') as YEAR_MONTH FROM DUAL
CONNECT BY ROWNUM < 12
Thanks,
Lakshman
|
|
|
Re: Query with CONNECT BY PRIOR [message #424035 is a reply to message #424030] |
Wed, 30 September 2009 00:40   |
 |
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
First of all, this is not query generating machine.
You have to first describe, what is your requirement.
What did you tried to get it.
What problems did you fetch.
Where have you stuck up.
And so on.
Moreover, you can not use anything (CONNECT BY PRIOR) anywhere( in your case)
regards,
Delna
[Updated on: Wed, 30 September 2009 00:43] Report message to a moderator
|
|
|
|