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;

posted @ 2018-10-29 11:54  淡蓝浅紫  阅读(648)  评论(0编辑  收藏  举报