[indopb] LOOPING dalam SQL

[Hermawan Dephe]

Dear PBers Mau nanya nih.. Saya punya syntax SQL pake oracle kayak gini nih.. ------------------------------------------------------------------------------------------------- select distinct obu,dept, b.wk_day, 0,    0,    0,    0,  to_char(sysdate,'yyyymmdd'), to_char(sysdate,'yyyymmdd'), 0,    0,    0,    0 from  tkupon a, (       select * from (       select to_char(to_date('201009'||'01','yyyymmdd')+0,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+1,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+2,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+3,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+4,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+5,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+6,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+7,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+8,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+9,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+10,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+11,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+12,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+13,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+14,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+15,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+16,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+17,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+18,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+19,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+20,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+21,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+22,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+23,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+24,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+25,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+26,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+27,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+28,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+29,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+30,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+31,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+32,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+33,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+34,'yyyymmdd') wk_day from dual         union       select to_char(to_date('201009'||'01','yyyymmdd')+35,'yyyymmdd') wk_day from dual         )       where wk_day like '201009'||'%') b where a.yyyymmdd='20100101' order by obu,dept, wk_day -------------------------------------------------------------------------------------------------     Syntax SQL tersebut saya kira terlalu panjang dan hanya mengulang ulang berkali kali " select to_char(to_date('201009'||'01','yyyymmdd')+ :X ,'yyyymmdd') wk_day from dual  " Kalo diringkas pake LOOPING gitu ada gak sih di SQL? nyoba gak jadi2... :( Tengkyu sebelum dan sesudahnya... Regards, Hermawan Dony Prasetyo IT Department PT. LP Displays Indonesia Phone :(62-21) 8989-511 Fax   :(62-21) 8980-282 email : hermawan...@lpdisplays.com  __._,_.___ ----------------------------------------------- IndoPB - Indonesia PB User Group http://groups.yahoo.com/group/indopb Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___