2008/3/12 Awaluddin Hamid <[EMAIL PROTECTED]>: > /* Oracle 10g */ > SELECT TO_CHAR(v_month,'YYYYMM') > FROM ( > SELECT ADD_MONTHS(v_min,LEVEL-1) v_month, v_max > FROM ( > SELECT MIN(daftar) v_min, MAX(daftar) v_max > FROM tbA) > CONNECT BY LEVEL < 1000) > WHERE v_month <= v_max; > > /* Oracle 8i */ > SELECT TO_CHAR(v_month,'YYYYMM') > FROM ( > SELECT ADD_MONTHS(v_min,v_rnum-1) v_month, v_max > FROM ( > SELECT MIN(daftar) v_min, MAX(daftar) v_max > FROM tbA a), (SELECT ROWNUM v_rnum FROM all_objects)) > WHERE v_month <= v_max; > > hth, > AH >
Very Nice..... :) terima kasih.. -- YM_id : muh_ilman_a http://misisawa.blogspot.com http://anrof.myminicity.com/ [Non-text portions of this message have been removed]
