recurisve clause query
boopathiAug 24 2010 — edited Aug 24 2010i want to generate the date using recurisve clause query
i/p : 24-AUg-2009 and depth = 4 ( dept is not fixed).
o/p should be as follows:
24-AUg-2009 - 0
25-AUg-2009 - 1
26-AUg-2009 - 2
27-AUg-2009 - 3
28-AUg-2009 - 4