SQL> -- Don't display any blob data.
SQL> set blob off;
SQL> select proj_desc
CON> from project
CON> where proj_id = 'HWRII';
PROJ_DESC
=================
85:e
SQL> -- Display all blob data.
SQL> set blobdisplay all;
SQL> select proj_desc
CON> from project
CON> where proj_id = 'HWRII';
PROJ_DESC
=================
85:e
==============================================================================
PROJ_DESC:
Integrate the hand-writing recognition module into the
universal language translator.
==============================================================================
SQL> -- Only display type 1 blob data = text.
SQL> set blob 1;
SQL> select proj_desc
CON> from project
CON> where proj_id = 'HWRII';
PROJ_DESC
=================
85:e
==============================================================================
PROJ_DESC:
Integrate the hand-writing recognition module into the
universal language translator.
==============================================================================
SQL> -- Only display blob type 7 = not text!
SQL> set blob 7;
SQL> select proj_desc
CON> from project
CON> where proj_id = 'HWRII';
PROJ_DESC
=================
85:e
==============================================================================
PROJ_DESC:
BLOB display set to subtype 7. This BLOB: subtype = 1
==============================================================================