
CODE: [Copy to clipboard]SQL_do.sql@echo off
sqlplus /nolog @SQL_do.sql
exit
CODE: [Copy to clipboard]--Use your own username, password, database
CONN username/password@database
SPOOL C:\result.xls
--Use your own SQL
SELECT SYSDATE FROM DUAL;
SPOOL OFF
EXIT
| 欢迎光临 中国DOS联盟论坛 (http://cndos.fam.cx/forum/) | Powered by Discuz! 2.5 |