SQL> set serveroutput on
SQL> DECLARE
2 r RAW(32767);
3 BEGIN
4 r := utl_raw.cast_to_raw('123456');
5 dbms_output.put_line(r);
6
7 r := utl_encode.base64_encode(r);
8 dbms_output.put_line(utl_raw.cast_to_varchar2(r));
9
10 r := utl_encode.base64_decode(r);
11 dbms_output.put_line(utl_raw.cast_to_varchar2(r));
12 END;
13 /
313233343536
MTIzNDU2
123456
PL/SQL procedure successfully completed
SQL> DECLARE
2 r RAW(32767);
3 BEGIN
4 r := utl_raw.cast_to_raw('123456');
5 dbms_output.put_line(r);
6
7 r := utl_encode.base64_encode(r);
8 dbms_output.put_line(utl_raw.cast_to_varchar2(r));
9
10 r := utl_encode.base64_decode(r);
11 dbms_output.put_line(utl_raw.cast_to_varchar2(r));
12 END;
13 /
313233343536
MTIzNDU2
123456
PL/SQL procedure successfully completed
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25323853/viewspace-715459/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25323853/viewspace-715459/