HEXTORAW function : HEXTORAW « Large Objects « Oracle PL / SQL

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

HEXTORAW function

 
SQL>
SQL> CREATE TABLE lobdemo (
  2    key NUMBER,
  3    clob_col CLOB,
  4    blob_col BLOB);

Table created.

SQL>
SQL>
SQL> DECLARE
  2    v_BLOB BLOB;
  3  BEGIN
  4    INSERT INTO lobdemo (key, blob_col)
  5      VALUES(55, HEXTORAW('0011223344556677889900AABBCCDDEEFF'))
  6      RETURNING blob_col INTO v_BLOB;
  7
  8    DBMS_OUTPUT.PUT_LINE(
  9      'Length of newly INSERTed BLOB is: ' ||
 10      DBMS_LOB.GETLENGTH(v_BLOB));
 11  END;
 12  /
Length of newly INSERTed BLOB is: 17

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table lobdemo;

Table dropped.

SQL>
SQL>

 

Related examples in the same category