摘要: ---- Generated by OCIULDR--OPTIONS(BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000)LOAD DATAINFILE 'xxxx.unl' "STR X'0a'"Append into TABLE temp_tableFIELDS TERMINATED BY X'7c' TRAILING NULLCOLS ( a CHAR(60), v CHAR(60))其中xxxx.unl就是平面定界文件。temp_table就是oracle数据的阅读全文
posted @ 2011-08-11 15:47 爱.辉.舞| 编辑 |
