Oracle PL/SQL/Large Objects/Update
Update BLOB, CLOB cloumn
<source lang="sql">
SQL> SQL> SQL> CREATE TABLE lobdemo (
2 key NUMBER PRIMARY KEY, 3 clob_col CLOB, 4 blob_col BLOB, 5 bfile_col BFILE 6 );
Table created. SQL> SQL> INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
2 VALUES (50, "This is a character literal", 3 HEXTORAW("FEFEFEFEFEFEFEFEFEFE"), 4 NULL);
1 row created. SQL> SQL> INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col)
2 VALUES (51, "This is another character literal", 3 HEXTORAW("ABABABABABABABABABAB"), 4 NULL);
1 row created. SQL> SQL> UPDATE lobdemo
2 SET blob_col = HEXTORAW("CDCDCDCDCDCDCDCDCDCDCDCD") 3 WHERE key IN (50, 51);
2 rows updated. SQL> SQL> SQL> DROP TABLE lobdemo; Table dropped. SQL> SQL>
</source>