--main.sql set linesize 200 set term off verify off feedback off pagesize 999 set up html on entmap ON spool on preformat off spool c:\tables.xls @get_tables.sql spool off --你在这里直接delete不就行了么? exit
用DBMs_scheduler.job 调用bat 文件,报错 -----bat set dbname=myoracle set username=scott set password=tiger sqlplus %username%/%password%@%dbname% @f:\workspace\123.sql pause---sql spool F:\workspace\123.txt select 123 from dual; spool off exit -----报错 STANDARD_ERROR="'sqlplus' 不是内部或外部命令,也不是可运行的程序 或批处理文件。" 怎么破?
--main.sql
set linesize 200
set term off verify off feedback off pagesize 999
set up html on entmap ON spool on preformat off
spool c:\tables.xls
@get_tables.sql
spool off
--你在这里直接delete不就行了么?
exit
-----bat
set dbname=myoracle
set username=scott
set password=tiger
sqlplus %username%/%password%@%dbname% @f:\workspace\123.sql
pause---sql
spool F:\workspace\123.txt
select 123 from dual;
spool off
exit
-----报错
STANDARD_ERROR="'sqlplus' 不是内部或外部命令,也不是可运行的程序
或批处理文件。"
怎么破?