DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: blob column

  1. #1
    Join Date
    Sep 2001
    hello friends

    i ve a few questions on blob column

    1. how to insert a value into the blob column.

    2. if i use the empty_blob() function to insert a value - what value is inserted
    is it a null.

    3. how to select a value from the blob column.

    4. if i ve inserted the blob column with the empty_blob() function
    how will i be able to retrive that data.


  2. #2
    Join Date
    Aug 2001
    Waterloo, On
    1. To insert value into a Blob column:

    (a) Initialize it by Empty_Blob() function.
    (b) Create a directory in Oracle corresponding to OS Dir
    from which you wish to load BLOB data.
    (c) Use DBMS_LOB package to load data. It has various
    functions like DBMS_LOB.LOADFROMFILE.
    (d) For an example, see

    2. No. It is not Null. The Column is Empty and is used for
    initialization so that it contains a locator.

    3. SQL PLUS cannot display lob columns, and thus you
    cannot 'select' BLOB column as you would other
    datatypes. However, you can develop your own
    procedures using DBMS_LOB package or other
    languages like PHP, Java etc.

    4. You can use DBMS_LOB.READ().

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.