- 论坛徽章:
- 0
|
如何使用pl/sql访问Access数据库?????
document
I hope you gave the tablename on the start command
otherwise you get an 'unknown command' error message
#
undefine quote
REM This procedure writes a comma delimited file
REM where tablename is the name of the table you want to output.
REM
accept delimiter char prompt 'Delimiter?'
accept nullvalue char prompt 'Null value?'
accept quote char prompt 'Type " for text to be surrounded by quotes '
set pause off
set echo off
set termout off
set newpage 1
set verify off
set feedback off
set pagesize 0
set linesize 75
set tab off
set scan
spool /tmp/stack.tmp
select decode (rownum,1,'select ','||''&delimiter''||')
|| decode (data_type,'NUMBER','decode(','''&"e''||')
|| column_name
||
decode(data_type,'NUMBER',',NULL,''&nullvalue'','||column_name
||')','||''&"e''')
from user_tab_columns
where table_name=upper('&1');
select 'templabel from &1' from dict where rownum=1;
prompt /
spool off
set linesize 132
set tab on
set trimout on
set termout on
set scan off
spool temp.txt
start /tmp/stack.tmp
spool OFF
set heading on
set linesize 80
set scan on
set pause on
set pagesize 23
set feedback on
host mv temp.dat "&1".txt |
|