Blob locator : BLOB « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. BLOB

SQL>
SQL>
SQL> CREATE TABLE myBlob
  2  (id NUMBER PRIMARY KEY,
  3   blob_data BLOB);

Table created.

SQL> DECLARE
  2    blobValue BLOB;
  3  BEGIN
  4    INSERT INTO myBlob VALUES (3,HEXTORAW('AAAAAAAAAAAAAAAAAAAA'));
  5    SELECT blob_data
  6    INTO blobValue
  7    FROM myBlob
  8    WHERE id =3;
  9
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table myBlob;

Table dropped.

SQL>
SQL>
SQL>