Ini mungkin maksudnya upload data di txt ke table kali yach??? kalo iya...yang mas bowo dulu ajarin aja ... ada kok di forum >.<
________________________________ Dari: wendi gunawan <[email protected]> Kepada: [email protected] Terkirim: Sel, 8 Juni, 2010 11:53:31 Judul: Re: [indo-oracle] Need help on oracle, query 3 tables kirain table..! klo file.txt kurang paham gmn bacanya klo di oracle.. monggo agan2 yg lain.. On Tue, Jun 8, 2010 at 4:50 PM, romy <[email protected]> wrote: > > > Gan klo pk awk bs gak ? > > tabelnya itu dalam bentuk file txt. > > > wendi gunawan wrote: > > > > > > oww sori gw revisi lagi.. > > > > select > > number as numbers, > > total_onnet as onnet, > > total_offnet as offnet, > > total_international as international, > > total_onnet+total_offnet+total_international as TOTAL > > > > from( > > select > > number, > > sum((case when jenis=1 then total else 0 end))total_onnet, > > sum((case when jenis=2 then total else 0 end)) total_offnet, > > sum((case when jenis=3 then total else 0 end)) total_international > > > > from( > > select number,total, 1 as jenis from t_onnet > > union all > > select number,total, 2 as jenis from t_offnet > > union all > > select number,total, 3 as jenis from t_international > > ) x > > group by number > > ) y > > > > On Tue, Jun 8, 2010 at 1:19 PM, wendi gunawan > > <[email protected]<wendi.gunawan%40gmail.com> > > <mailto:wendi.gunawan%40gmail.com <wendi.gunawan%2540gmail.com>>>wrote: > > > > > > select > > > number as numbers, > > > total_onnet as onnet, > > > total_offnet as offnet, > > > total_international as international, > > > total_onnet+total_offnet+total_international as TOTAL > > > > > > from( > > > select > > > number, > > > sum((case when jenis=1 then total else 0 end))total_onnet, > > > sum((case when jenis=2 then total else 0 end)) total_offnet, > > > sum((case when jenis=3 then total else 0 end)) total_international > > > > > > from( > > > > > > select number,count(*) total, 1 as jenis from t_onnet > > > group by number > > > union all > > > select number,count(*) total, 2 as jenis t_offnet > > > group by number > > > union all > > > select number,count(*) total, 3 as jenis t_international > > > group by number > > > ) x > > > group by number > > > ) y > > > > > > > > > > > -- wendi gunawan Java Software Developer & penulis (new bie) terus belajar untuk tidak cinta dunia http://oretanwendi.wordpress.com/ hp:085624046906 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
