Mungkin bisa disertakan script dari view VIEW_LOADER_ACCEPT_ASCII. Sepertinya kejadian dibawah tidak mungkin terjadi pada table.
regards, tomi --- indra syafruddin <[EMAIL PROTECTED]> wrote: > Saya coba jalanin query : > > "SELECT * FROM "SMSAPP2".VIEW_LOADER_ACCEPT_ASCII s > where to_char(s.END_TIME, 'DD-MM-YYYY') like > '14-02-2007' > and s.NODE_ID = 'combdg01' " > > > tapi muncul error ORA-01858: a non-numeric character > was found where a > numeric was expected > > > tetapi, jika saya ganti NODE_ID nya, data bisa > dimunculkan : > > SELECT * FROM "SMSAPP2".VIEW_LOADER_ACCEPT_ASCII s > where to_char(s.END_TIME, 'DD-MM-YYYY') like > '14-02-2007' > and s.NODE_ID = 'combjm01' > > Ada yang bisa bantu cari solusinya? > Data loader diambil menggunakan sqlloader. > > Terima kasih sebelumnya. > ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091
