Kalau mau langsung "tembak" ke text file lewat Oracle database, gunakan fitur external table. Dijamin bisa query langsung ke text file via external table tsb, dengan catatan : 1. text file HARUS berada di database server atau bisa diakses langsung oleh database (misal: pakai NFS kalau filenya di remote server) 2. text file-nya HARUS punya format baku (bisa fixed length atau menggunakan delimiter) 3. jumlah text filenya boleh satu, dua, tiga,....
cmiiw, bw bw --- In [email protected], "izzudin.hanafie" <izzudin...@...> wrote: > > Kenapa ngga di load saja dulu ke dalam suatu table di database, baru setelah > itu dilakukan query pak.. > > Salam, > > IH > > --- On Tue, 6/8/10, romy <romy.hua...@...> wrote: > > From: romy <romy.hua...@...> > Subject: Re: [indo-oracle] Need help on oracle, query 3 tables > To: [email protected] > Date: Tuesday, June 8, 2010, 5:50 AM > > > > > > > > Â > > > > > > > > > > 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 <wendi.guna...@... > > > <mailto:wendi.gunawan%40gmail.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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] >
