tom写的一个用来生成为sqlldr准备的格式.
其中有unix和windows两个版本.
在itpub中有人已经上传.
具体可以到这里下载:
http://www.itpub.net/thread-927857-1-1.html
关于这个脚本,需要注意的是,由于tom只是输出一个例子.因此并未把数据写入至文件,
其实稍把sqlldr_exp.sql脚本作一修改即可实现, 如下:
set wrap off
set linesize 100
set feedback off
set pagesize 0
set verify off
set termout off
spool ytmpy.sql
prompt set head off;
prompt set feedback off;
prompt spool aa.txt
prompt prompt LOAD DATA
prompt prompt INFILE *
prompt prompt INTO TABLE &1
prompt prompt REPLACE
prompt prompt FIELDS TERMINATED BY '|'
prompt prompt (
select 'prompt ' || decode(column_id,1,'',',') || lower(column_name)
from user_tab_columns
where table_name = upper('&1')
order by column_id
/
prompt prompt )
prompt prompt BEGINDATA
prompt select
select lower(column_name)||'||chr(124)||'
from user_tab_columns
where table_name = upper('&1') and
column_id != (select max(column_id) from user_tab_columns where
table_name = upper('&1'))
order by column_id
/
select lower(column_name)
from user_tab_columns
where table_name = upper('&1') and
column_id = (select max(column_id) from user_tab_columns where
table_name = upper('&1'))
order by column_id
/
prompt from &1
prompt /
prompt spool off
prompt set feedback on
prompt set head on
spool off
set termout on
@ytmpy.sql
exit
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/104152/viewspace-168405/ ，如需转载，请注明出处，否则将追究法律责任。
