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

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');

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

1. insert into mytable(id, myblob) values (1,EMPTY_BLOB);
2. SELECT * FROM mytable mt where mt.id=1 for update
3. Click on the Lock icon to unlock for editing
4. Click on the ... next to the BLOB to edit
5. Select the appropriate tab and click open on the top left.
6. Click OK and commit the changes.