Thanx Mr Tomi & Mr Bowo. Its works!!! SOL
----- Original Message ---- From: Tomi Wijanto <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, February 13, 2007 12:44:21 PM Subject: Re: [indo-oracle] Re: External table Misalkan semua file memiliki struktur yang sama, maka Anda bisa membaca satu file pada satu waktu, setelah selesai bisa switch utk membaca file lainnya. Misalkan Anda telah membuat external table yang by default membaca file data1.dat. Utk membaca data dari file data2.dat, kemudian data3.dat, dst, maka alter lokasi file external table dengan: alter table mytable location( 'data2.dat' ); select * from mytable; alter table mytable location( 'data3.dat' ); select * from mytable; Kalau list dari semua file disimpan di table, maka Anda bisa membuat sebuah program pl/sql utk memproses semua file tersebut (utk alter table, pakai 'execute immediate'). regards, tomi --- agas <[EMAIL PROTECTED] com> wrote: > Sayangnya nama filenya dinamis pak bowo, sesuai > dengan jam dibuat (ddmmyyyy_hh24: mi:ss). > > Contoh: > data_13022007_ 11:00:00 > data_13022007_ 12:00:00 > data_13022007_ 13:00:00 > > Kalau mau pakai program, bagaimanakah lojik > programnya? > > Apakah braveheart punya contoh java stored > procedurenya? > ____________ _________ _________ _________ _________ _________ _ Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. http://answers. yahoo.com/ dir/?link= list&sid= 396545367 <!-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px 8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial; font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} --> ____________________________________________________________________________________ Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097 [Non-text portions of this message have been removed]
