有多个id的值中间使用逗号隔开的字段，转换成表的函数应该怎么做。下面的是逗号隔开的字段转换成表的函数参考存储过程，我看不懂是什么意思

0 0

有多个id的值中间使用逗号隔开的字段，转换成表的函数应该怎么做。下面的是逗号隔开的字段转换成表的函数参考存储过程，我看不懂是什么意思 5

CREATE OR REPLACE PROCEDURE Proc_assign_participate2(deployed_id     IN VARCHAR2,
                                                     activity_name   IN VARCHAR2,
                                                     v_org_id        IN VARCHAR2,
                                                     v_operation_id in VARCHAR2,
                                                     v_filter_option in varchar2,
                                                     ref_cursor      OUT SYS_REFCURSOR) IS
BEGIN
OPEN ref_cursor FOR
    select sys_user.sys_user_id
      from user_role, role_operation, operation, operation_class, sys_user
     where user_role.role_id = role_operation.role_id
       and role_operation.operation_id = operation.operation_id
       and operation_name = activity_name
       and operation.operation_class_id =
           operation_class.operation_class_id
       and operation_class.deployment_id = deployed_id
       and user_role.sys_user_id = sys_user.sys_user_id
       and role_operation.operation_id = v_operation_id
       and (v_filter_option is null or exists
            (select 1
               from (select regexp_substr(v_filter_option, '[^,]+', 1, level) o
                       from dual
                     connect by regexp_substr(v_filter_option,
                                              '[^,]+',
                                              1,
                                              level) is not null)
              where instr(',' || role_operation.options || ',',
                          ',' || o || ',') > 0))
       and sys_user.org_id in
           (SELECT org_id
              FROM orgnization org
             START WITH org.org_id = v_org_id
            CONNECT BY PRIOR org.org_id = org.parent_org_id);

END proc_assign_participate2;

2012年5月17日 15:51