add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.14
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
CREATE FUNCTION clob_to_blob( value IN CLOB, charset_id IN INTEGER DEFAULT DBMS_LOB.DEFAULT_CSID, error_on_warning IN NUMBER DEFAULT 0 ) RETURN BLOB IS result BLOB; dest_offset INTEGER := 1; src_offset INTEGER := 1; lang_context INTEGER := DBMS_LOB.DEFAULT_LANG_CTX; warning INTEGER; warning_msg VARCHAR2(50); BEGIN DBMS_LOB.CreateTemporary( lob_loc => result, cache => TRUE ); DBMS_LOB.CONVERTTOBLOB( dest_lob => result, src_clob => value, amount => LENGTH( value ), dest_offset => dest_offset, src_offset => src_offset, blob_csid => charset_id, lang_context => lang_context, warning => warning ); IF warning != DBMS_LOB.NO_WARNING THEN IF warning = DBMS_LOB.WARN_INCONVERTIBLE_CHAR THEN warning_msg := 'Warning: Inconvertible character.'; ELSE warning_msg := 'Warning: (' || warning || ') during CLOB conversion.'; END IF; IF error_on_warning = 0 THEN DBMS_OUTPUT.PUT_LINE( warning_msg ); ELSE RAISE_APPLICATION_ERROR( -20567, -- random value between -20000 and -20999 warning_msg ); END IF; END IF; RETURN result; END clob_to_blob; /
CREATE FUNCTION blob_to_clob( value IN BLOB, charset_id IN INTEGER DEFAULT DBMS_LOB.DEFAULT_CSID, error_on_warning IN NUMBER DEFAULT 0 ) RETURN CLOB IS result CLOB; dest_offset INTEGER := 1; src_offset INTEGER := 1; lang_context INTEGER := DBMS_LOB.DEFAULT_LANG_CTX; warning INTEGER; warning_msg VARCHAR2(50); BEGIN DBMS_LOB.CreateTemporary( lob_loc => result, cache => TRUE ); DBMS_LOB.CONVERTTOCLOB( dest_lob => result, src_blob => value, amount => LENGTH( value ), dest_offset => dest_offset, src_offset => src_offset, blob_csid => charset_id, lang_context => lang_context, warning => warning ); IF warning != DBMS_LOB.NO_WARNING THEN IF warning = DBMS_LOB.WARN_INCONVERTIBLE_CHAR THEN warning_msg := 'Warning: Inconvertible character.'; ELSE warning_msg := 'Warning: (' || warning || ') during BLOB conversion.'; END IF; IF error_on_warning = 0 THEN DBMS_OUTPUT.PUT_LINE( warning_msg ); ELSE RAISE_APPLICATION_ERROR( -20567, -- random value between -20000 and -20999 warning_msg ); END IF; END IF; RETURN result; END blob_to_clob; /
CREATE TABLE table_name ( value BLOB );
INSERT INTO table_name (value ) VALUES ( CLOB_TO_BLOB( 'abcdefg' ) );
1 rows affected
SELECT BLOB_TO_CLOB( value ) FROM table_name;
BLOB_TO_CLOB(VALUE)
abcdefg