Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Base64 to binary conversion

443723Mar 25 2010
Hi,

Is there any built in function to conver Base64 to binary.

I have a CLOB column which can have at the most 5600 character string which is in Base64 format.

I have tried using below code but it is not providing me the required result.

SQL> create or replace procedure p1
2 AS
3 v_cast_to_raw RAW(32767);
4 v_base64_decode RAW(32767);
5 v_cast_to_bin binary_integer;
6 v_cast_to_num number;
7 i_param1 CLOB;
8 v_var varchar2(32767);
9 BEGIN
10
11 SELECT c_base64 INTO i_param1 FROM t_base64;
12
13 v_cast_to_raw := utl_raw.cast_to_raw(substr(i_param1,1,5400));
14 v_base64_decode := utl_encode.base64_decode(v_cast_to_raw);
15 dbms_output.put_line('Base64 string :' || i_param1 );
16 dbms_output.put_line('v_cast_to_raw :' || v_cast_to_raw );
17 dbms_output.put_line('v_base64_decode :' || v_base64_decode );
18 dbms_output.put_line('v_cast_to_varchar2 :' || UTL_RAW.cast_to_varchar2(v_base64_decode));
19 dbms_output.put_line('v_cast_to_number :' || UTL_RAW.cast_to_number(v_base64_decode));
20
21 end p1;
22 /

Procedure created.

Elapsed: 00:00:00.03
SQL> BEGIN P1; END;
2 /
Base64 string
:ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICIgICAgICAiICAoICAgICAgKCAgICIgICAgICAgICAoICAgIiAgKiAgICAgICggICAiICAqICAgICAgICAiIiIoIiIiMiIiIiI6MjAgIjIgKiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAkICAgICBgYCAhICBgYGAgYCAgYGBgIGAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAggICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA==
v_cast_to_raw
:4943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
7494341674943556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556C4A53556
C4A53556C4A53556C4A53556C4A53456749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
74943416749434167494341674943416749434167494341674943416749434167494341674943416
749434167494341674943416749434167494341674943416749434167494341674943416749413D3
D
v_base64_decode
:2020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252525252525252525252
52525252525252525252525252525252525252525252525252525252525252120202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202020202020202
02020202020202020
v_cast_to_varchar2 :
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%!
v_cast_to_number
:-69696969696969696969696969696969696969690000000000000000000000

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.02
SQL> spool off;


Please let me know is there any other way to decode base64 into binary.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2010
Added on Mar 25 2010
#database, #oracle, #pl-sql, #plsql, #sql
0 comments
660 views