oracle中如何实现blob和base64相互转换

2025-04-15 12:16:42
推荐回答(1个)
回答1:

1. base64 decode

select utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw('dGVzdA=='))) from dual


2. base64 encode

select utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw('test'))) from dual