Use update statement to change the value in blob type column : BLOB « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. BLOB

SQL>
SQL> create table demo
  2  ( id           int primary key,
  3    theBlob      blob
  4  )
  5  /

Table created.

SQL>
SQL>
SQL> update demo  set theBlob = 'Hello World'
  2  where id = 1
  3  /

0 rows updated.

SQL>
SQL>
SQL>
SQL> drop table demo;

Table dropped.