select empno,ename,job,sal from emp where deptno=&1 and sal>&2;
在SQL*PLUS下带参数调用 c:\sql1.sql
SQL> c:\sql1.sql 20 1500
输入被截为66个字符
原值 1: select empno,ename,job,sal from emp where deptno=&1 and sal>&2
新值 1: select empno,ename,job,sal from emp where deptno=20 and sal>1500
db2 没有类似的吗??