oracle存储过程实际返回行数

2025-12-17 02:54:54
推荐回答(1个)
回答1:

oracle存储过程实际返回行数
CREATE OR REPLACE PROCEDURE OPE_SELECT (
loginname_i in TBL_OPERATEINFO.loginname%type,
ref_cursor out sys_refcursor
) AS
BEGIN
open ref_cursor for
SELECT name FROM TBL_OPERATEINFO WHERE loginname LIKE '%' || loginname_i || '%' ;
END OPE_SELECT;