kurs:sqlldr_sql_loader
Differences
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] (current) 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> | ||
kurs/sqlldr_sql_loader.1288880029.txt.gz · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
