本文介绍了一段PL/SQL代码示例，展示了如何声明并使用局部变量和游标。通过一个具体的例子，说明了如何从角色表中获取用户ID为2的角色名称，并将这些名称拼接成一个字符串。
-- Created on 2014/3/10 by EX_ZHANGKENAN
declare
-- Local variables here
v_name VARCHAR2(50);
v_len INTEGER;
CURSOR cursor_name IS SELECT role_name INTO v_name FROM t_role WHERE role_id IN (SELECT role_id FROM T_USER_ROLE WHERE user_id = '2' ) ;
begin
-- Test statements here
FOR current_name IN cursor_name LOOP
v_name := v_name||current_name.ROLE_NAME||',';
END LOOP;
SELECT length(v_name) INTO v_len FROM dual;
SELECT substr(v_name,1,v_len-1) INTO v_name FROM dual;
end;
declare
-- Local variables here
v_name VARCHAR2(50);
v_len INTEGER;
CURSOR cursor_name IS SELECT role_name INTO v_name FROM t_role WHERE role_id IN (SELECT role_id FROM T_USER_ROLE WHERE user_id = '2' ) ;
begin
-- Test statements here
FOR current_name IN cursor_name LOOP
v_name := v_name||current_name.ROLE_NAME||',';
END LOOP;
SELECT length(v_name) INTO v_len FROM dual;
SELECT substr(v_name,1,v_len-1) INTO v_name FROM dual;
end;
扫一扫
528
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
