17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure p_getid(v_id number)
as
v_name varchar2(100);
cur sys_refcursor;
begin
open cur for 'select name from a where relatedid like '||'''%'||v_id||'%''';
loop
fetch cur into v_name;
exit when cur%notfound;
dbms_output.put_line(v_name);
end loop;
close cur;
end;
/