Update BLOB, CLOB cloumn : Update « Large Objects « Oracle PL / SQL

1. Oracle PL / SQL
2. Large Objects
3. Update

Update BLOB, CLOB cloumn

 
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>

 

Related examples in the same category