原文地址:在ORACLE的存储过程中如何做简单的动态查询
作者:HK工作室
CREATE OR REPLACE procedure ZXM_SB_GZ_GET
(p_table in varchar2,
p_name in varchar2,
p_value in varchar2,
outpara out lntxdba.zxm_pag_cs_power.c_type
)
as
begin
declare
wherevalue varchar2(200);
begin
wherevalue:=select * from ||p_table|| where ||p_name||=||p_value;
open outpara for
wherevalue;
end;
end;
(p_table in varchar2,
p_name in varchar2,
p_value in varchar2,
outpara out lntxdba.zxm_pag_cs_power.c_type
)
as
begin
declare
wherevalue varchar2(200);
begin
wherevalue:=select * from ||p_table|| where ||p_name||=||p_value;
open outpara for
wherevalue;
end;
end;