dokuwiki

Datei unter c:\temp\emp.ldr abspeichern

LOAD DATA
INFILE *
BADFILE badfile.csv
append
INTO TABLE bonus
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(employee_id "employees_seq.nextval", first_name, last_name)
BEGINDATA
,bla,"fa,sel"
,blu,fusel
,bli,fisel

\> cd C:\app\product\11.1.0\db_1\BIN

C:\app\product\11.1.0\db_1\BIN>sqlldr.exe hr/hr control=c:\temp\emp.ldr

cvs exportieren

sqlplus username/password@string <<EOF
set feed off markup html on spool on
spool c:\temp\filename
select * from <table>;
spool off
set markup html off spool off