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

Thread: blob column

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69
    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.

    regards
    swaminathan

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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
    http://www.dbasupport.com/forums/showthread.php?
    threadid=17608

    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