Oacle-经典SQL语句

• 将字符串分割为表

select regexp_substr('1,2,3,4,5', '[^,]+', 1, level) user_role, level lv
  from dual
connect by regexp_substr('1,2,3,4,5', '[^,]+', 1, level) is not null;

• 给加密包赋权限(用具有sysdba的用户赋权限)

grant execute on sys.dbms_crypto to user_name;