Converting binary to varchar in PL/SQL

I suggest using TO_CHAR function. See TO_CHAR.As in

SELECT TO_CHAR(col14,'99999999') FROM sample_table

Please see linked documentation for the desired format according to your requirements.

oracle plsql binary varchar

Use cast function:

CAST ( { expr | ( subquery ) | MULTISET ( subquery ) } AS type_name )

so:

select CAST(col_14 as varchar2(20)) from sample_tabe

For more, check this link:

CodeHunter