SQL & PL/SQL

Hi All ,

Let us considering the below on Oracle DB 12c:

create table xx_test3 (c blob);

insert into xx_test3 (c) values (utl_raw.cast_to_raw(
'azertyuiop,qsdfghjklm,wxcvbn'));


create table xx_target (col1 varchar2(50));

Can somebody guides me how to read the data and insert it in xx_target table ?

Result needed is :

select * from xx_target;


COL1                                              

--------------------------------------------------
azertyuiop                                        
qsdfghjklm                                        
wxcvbn                                            

3 rows selected.

Thanks in advance,

Stoyanov.