PL/SQL 查询条件中使用 like

最新推荐文章于 2023-08-08 19:08:07 发布

野夫

最新推荐文章于 2023-08-08 19:08:07 发布

阅读量2.6k

点赞数

本文链接：https://blog.csdn.net/robin258/article/details/80172166

版权

set serveroutput on
declare
type ref_trans is ref cursor;
tranRef ref_trans;
v_trns emp%rowtype;
str varchar2(200);
--v_channel varchar2(50);
letter char:= 'A';
begin
loop
str := 'select channel from BPHADMIN.emp where channel like '''||letter||'%''';
open tranRef for str;
loop
fetch tranRef into v_trns.channel;
Exit when tranRef%notfound;
dbms_output.put_line(v_trns.channel);
end loop;
exit when letter='Z';
letter:= chr(ascii(letter)+1);
end loop;
end;