declare
begin
/* spool $KES_HOME/tmp/tbl_sys_total_gyosyaSQL.log
delete tbl_sys_total_gyosya where nendo='&1' */
select * from testt;
-- ***** modify start V8.00 *****
/* select nendo, gyosyu_cd, entry_no
from tbl_sys_total_gyosya
where nendo = '&1'; */
SELECT NENDO, GYOSYU_CD, ENTRY_NO_DATA
FROM TBL_TMP_UKETUKE_NO
GROUP BY NENDO,GYOSYU_CD,ENTRY_NO_DATA;
-- ***** modify end V8.00 *****
end;
如上所示,对‘&1’的注释是无效的,程序仍然要让我输入。而如下
/* spool $KES_HOME/tmp/tbl_sys_total_gyosyaSQL.log
delete tbl_sys_total_gyosya where nendo='&1' */
select * from testt;
-- ***** modify start V8.00 *****
/* select nendo, gyosyu_cd, entry_no
from tbl_sys_total_gyosya
where nendo = '&1'; */
SELECT NENDO, GYOSYU_CD, ENTRY_NO_DATA
FROM TBL_TMP_UKETUKE_NO
GROUP BY NENDO,GYOSYU_CD,ENTRY_NO_DATA;
-- ***** modify end V8.00 *****
不生明为块函数却可以注释掉。
想请教,的是如何才能将块函数中的‘&1’注释掉。(不能删除)
|