用SPOOL 盘符:\*.SQL ........ SPOOL OFF 然后在把SQL文件导入MYSQL
导出文本:spool 或者utl_file包,或者借助第三方工具
能写的详细点吗,我是个初学者,不太会用Oracle
set pagesize 0 set sqlblanklines off set trimspool on set heading off set feedback off set linesize 200 set trimspool off set echo off spool .\name.txt select name from student / spool off quit
........
SPOOL OFF
然后在把SQL文件导入MYSQL
set pagesize 0
set sqlblanklines off
set trimspool on
set heading off
set feedback off
set linesize 200
set trimspool off
set echo off
spool .\name.txt select name from student
/
spool off
quit
select 一下 把结果数据全选中 右件 COPY TO EXCEL