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.
[Non-text portions of this message have been removed]
