是要这种效果吗?SQL> select empno, ename from emp where empno=&no; 输入 no 的值: 7934 原值 1: select empno, ename from emp where empno=&no 新值 1: select empno, ename from emp where empno=7934 EMPNO ENAME ---------- ---------- 7934 MILLERSQL>
可以创建存储过程 create or replace procedure selectvalueByparame( parame number) as beginselect * from table_a where column_b=parame;end; /
create or replace procedure result_proc(p_param in varchar2,p_cur in out sys_refcursor) as begin open p_cur for 'select * from table_a where column_b='||p_param;end result_proc;
open p_cur for select * from table_a where column_b=p_param;
输入 no 的值: 7934
原值 1: select empno, ename from emp where empno=&no
新值 1: select empno, ename from emp where empno=7934 EMPNO ENAME
---------- ----------
7934 MILLERSQL>
as
beginselect * from table_a where column_b=parame;end;
/
as
begin
open p_cur for 'select * from table_a where column_b='||p_param;end result_proc;