This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:sqlldr_sql_loader [2010/11/04 15:13] mh |
kurs:sqlldr_sql_loader [2015/04/29 10:05] mh |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | Datei unter c:\temp\emp.ldr abspeichern | ||
+ | |||
<code> | <code> | ||
LOAD DATA | LOAD DATA | ||
INFILE * | INFILE * | ||
+ | BADFILE badfile.csv | ||
append | append | ||
INTO TABLE bonus | INTO TABLE bonus | ||
Line 12: | Line 15: | ||
</code> | </code> | ||
- | sqlldr hr/hr c:\temp\data.ctl direct=yes | + | \> 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 | ||
+ | |||
+ | <code> | ||
+ | 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 | ||
+ | </code> |