oracel学习之：sqluldr2使用

#include
#include "sqluldr2.h"
void main()
{
void *h &＃61; NULL;
SQLULDR2HandleAlloc(&h);
if(h !&＃61; NULL)
{
SQLULDR2HandleSetAttr(h, "USER&＃61;SYS");
SQLULDR2HandleSetAttr(h, "QUERY&＃61;SELECT * FROM TAB");
SQLULDR2HandleExecute(h);
SQLULDR2HandleFree(h);
}
}


C:\Users\meng\Desktop\sqluldr2>sqluldr2.exe help&＃61;yes
SQL*UnLoader: Fast Oracle Text Unloader (GZIP, Parallel), Release 4.0.1
(&＃64;) Copyright Lou Fangxin (AnySQL.net) 2004 - 2010, all rights reserved.
License: Free for non-commercial useage, else 100 USD per server.
Usage: SQLULDR2 keyword&＃61;value [,keyword&＃61;value,...]
Valid Keywords:
user &＃61; username/password&＃64;tnsname
sql &＃61; SQL file name
query &＃61; select statement
field &＃61; separator string between fields
record &＃61; separator string between records
rows &＃61; print progress for every given rows (default, 1000000)
file &＃61; output file name(default: uldrdata.txt)
log &＃61; log file name, prefix with &＃43; to append mode
fast &＃61; auto tuning the session level parameters(YES)
text &＃61; output type (MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).
charset &＃61; character set name of the target database.
ncharset&＃61; national character set name of the target database.
parfile &＃61; read command option from parameter file
read &＃61; set DB_FILE_MULTIBLOCK_READ_COUNT at session level
sort &＃61; set SORT_AREA_SIZE at session level (UNIT:MB)
hash &＃61; set HASH_AREA_SIZE at session level (UNIT:MB)
array &＃61; array fetch size
head &＃61; print row header(Yes|No)
batch &＃61; save to new file for every rows batch (Yes/No)
size &＃61; maximum output file piece size (UNIB:MB)
serial &＃61; set _serial_direct_read to TRUE at session level
trace &＃61; set event 10046 to given level at session level
table &＃61; table name in the sqlldr control file
control &＃61; sqlldr control file and path.
mode &＃61; sqlldr option, INSERT or APPEND or REPLACE or TRUNCATE
buffer &＃61; sqlldr READSIZE and BINDSIZE, default 16 (MB)
long &＃61; maximum long field size
width &＃61; customized max column width (w1:w2:...)
quote &＃61; optional quote string
data &＃61; disable real data unload (NO, OFF)
alter &＃61; alter session SQLs to be execute before unload
safe &＃61; use large buffer to avoid ORA-24345 error (Yes|No)
crypt &＃61; encrypted user information only (Yes|No)
sedf/t &＃61; enable character translation function
null &＃61; replace null with given value
escape &＃61; escape character for special characters
escf/t &＃61; escape from/to characters list
format &＃61; MYSQL: MySQL Insert SQLs, SQL: Insert SQLs.
exec &＃61; the command to execute the SQLs.
prehead &＃61; column name prefix for head line.
rowpre &＃61; row prefix string for each line.
rowsuf &＃61; row sufix string for each line.
colsep &＃61; separator string between column name and value.
presql &＃61; SQL or scripts to be executed before data unload.
postsql &＃61; SQL or scripts to be executed after data unload.
lob &＃61; extract lob values to single file (FILE).
lobdir &＃61; subdirectory count to store lob files .
split &＃61; table name for automatically parallelization.
degree &＃61; parallelize data copy degree (2-128).
hint &＃61; MySQL SQL hint for the Insert, for example IGNORE.
unique &＃61; Unique Column List for the MySQL target table.
update &＃61; Enable MySQL ON DUPLICATE SQL statement(YES/NO).
for field and record, you can use &＃39;0x&＃39; to specify hex character code,
\r&＃61;0x0d \n&＃61;0x0a |&＃61;0x7c ,&＃61;0x2c, \t&＃61;0x09, :&＃61;0x3a, #&＃61;0x23, "&＃61;0x22 &＃39;&＃61;0x27
C:\Users\meng\Desktop\sqluldr2>