将oracle数据库表使用命令的形式导入到excle文件中 亲测可用！

set linesize 200 
set term off verify off feedback off pagesize 999 
set markup html on entmap ON spool on preformat off
spool D:新建文件夹mick	ables.xls
@get_tables.sql
spool off
exit

select * from user_tables ;

@echo off
sqlplus  as sysdba @ D:main.sql
pause