ORACLE 存储过程 like 样例

create or replace procedure PROC_Test_User(vF_username in varchar2, out_Refcursor out sys_refcursor) is
begin
open out_Refcursor for
SELECT u.* FROM tb_system_user u WHERE 1 > 0 AND u.f_username LIKE '%' ||vF_username || '%';
end PROC_Test_User;

转载于:https://www.cnblogs.com/shejiewei/p/9869871.html