How to write a query to retrieve only the months from certain given duration.

I will be getting this duration from the dual table. Provide query for this.

Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only 4 months like Jan, Feb, Mar, Apr.
Btu not the whole dates. Only four rows has to be retrieved. This should be retrieved from the dual table but not from other tables.

Interview Candidate
Jun 21st, 2007
3
1748

Basics

Answer

Showing Answers 1 - 3 of 3 Answers

taraldesai
Profile Answers by taraldesai

Jun 23rd, 2007

group by month..and put where date between

jamesravid
Profile Answers by jamesravid

Jul 18th, 2007

Use this query,

select to_char(add_months('01-jan-2007',rownum-1),'MON') from user_objects where add_months('01-jan-2007',rownum-1) < '30-apr-2007';

Imran_Javed
Profile Answers by Imran_Javed

May 13th, 2008

SELECT
TO_CHAR(ADD_MONTHS('01-jan-2007',
ROWNUM-1),
'MON')
FROM
dual
WHERE
ADD_MONTHS('01-jan-2007',ROWNUM-1) < '30-apr-2007'
CONNECT BY LEVEL <=12;