新建data.sql onnect scott/123 set line 130 set pagesize 1000 set heading on spool c:\sql\date.txt select deptno ||',' ||dname||',' shujukui from dept; spool off; exit 新建down.bat sqlplus /nolog @data.sql exit
本文共 255 字，大约阅读时间需要 1 分钟。
新建data.sql onnect scott/123 set line 130 set pagesize 1000 set heading on spool c:\sql\date.txt select deptno ||',' ||dname||',' shujukui from dept; spool off; exit 新建down.bat sqlplus /nolog @data.sql exit
转载于:https://my.oschina.net/u/2511906/blog/1143130