Saturday, July 24, 2010

Upload from csv via sql command

set termout off
set hea off
set pagesize 0

spool c:\whatever.csv

select a.a||','||a.b||','||a.c
from a
where a.a="whatever";

spool off

2 comments:

  1. asmikum a gimana kbr nya ? lagi belajar posting a,ga apal2.di tunggu a blas posting baliknya.

    ReplyDelete
  2. 'alaikum salam nggo, silahken ...
    sory lagi banyak kerjaan jadi ngga cepet reply

    ReplyDelete