CLOB 和 BLOB
An SQL CLOB
is a built-in type that stores a Character Large Object as a column value in a row of a database table.
An SQL BLOB
is a built-in type that stores a Binary Large Object as a column value in a row of a database table.
Introduction to Large Objects
https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_intro.htm#ADLOB001
TO_BLOB
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions186.htm#SQLRF30029
SELECT TO_BLOB(raw_column) blob FROM raw_table;
TO_CLOB
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions182.htm
UPDATE PRINT_MEDIA SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步