Odi's astoundingly incomplete notes

New entries | Code

Cast CLOB to BLOB in Oracle

select TO_BLOB(UTL_RAW.CAST_TO_RAW(myclob)) from mytable
This will provide a CLOB column as a BLOB. The character set / encoding that is used here is to be determined. Probably DB default.
posted on 2021-11-19 13:15 UTC in Code | 0 comments | permalink