How can I insert into a BLOB column from an insert statement in sqldeveloper

Question

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

User · Answer

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

User · Answer

Yes  it s possible  e g  using the implicit conversion from RAW to BLOB   insert into blob fun values 1  hextoraw  453d7a34       453d7a34 is a string of hexadecimal values  which is first explicitly converted to the RAW data type and then inserted into the BLOB column  The result is a BLOB value of 4 bytes

User · Answer

insert into mytable id  myblob  values  1 EMPTY BLOB    SELECT   FROM mytable mt where mt id 1 for update Click on the Lock icon to unlock for editing Click on the     next to the BLOB to edit Select the appropriate tab and click open on the top left  Click OK and commit the changes

[oracle] How can I insert into a BLOB column from an insert statement in sqldeveloper?

Examples related to oracle

Examples related to blob

Examples related to oracle-sqldeveloper