3,491
社区成员
发帖
与我相关
我的任务
分享
procedure get_info(v_column in varchar,p_cursor out TEST.cursortype)
as
begin
open p_cursor for
select v_column from A;
end;
--最好用存储过程来做,你需要动态SQL来拼接,用动态游标来返回结果:
create or replace procedure get_info(v_column in varchar,p_cursor out sys_refcursor)
as
begin
open p_cursor for 'select '||v_column||' from A';
end;
create or replace procedure get_info(v_column in varchar,p_cursor out sys_refcursor)
as
begin
open p_cursor for 'select '||v_column||' from A';
end;