Menu
Is it possible to insert into a BLOB column in oracle using sqldeveloper?
i.e. something like:
insert into mytable(id, myblob) values (1,'some magic here'); 
301
The database server provides SQL functions that you can call from within an INSERT statement to import and export BLOB or CLOB data, otherwise known as smart large objects. For a description of these functions, see Smart large object functions.
You can initialize a BLOB column value by using the function EMPTY_BLOB() as a default predicate. Similarly, a CLOB or NCLOB column value can be initialized by using the function EMPTY_CLOB() . You can also initialize a LOB column with a character or raw string less than 4000 bytes in size.
To insert a VARCHAR2 into a BLOB column you can rely on the function utl_raw.cast_to_raw as next:
insert into mytable(id, myblob) values (1, utl_raw.cast_to_raw('some magic here')); It will cast your input VARCHAR2 into RAW datatype without modifying its content, then it will insert the result into your BLOB column.
More details about the function utl_raw.cast_to_raw
109
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
