User Tools

Site Tools


kurs:sqlldr_sql_loader

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
kurs/sqlldr_sql_loader.txt · Last modified: 2015/04/29 10:05 by mh