viewing BLOB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: viewing BLOB

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    Is there any way to know if you have data in a BLOB field?
    I can't visualize the field with my SQL* Plus worksheet,but maybe I can guess just if I have data or not in it...
    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jamoji
    Is there any way to know if you have data in a BLOB field?
    I can't visualize the field with my SQL* Plus worksheet,but maybe I can guess just if I have data or not in it...
    Thanks
    Yes. Assume that your table is calle BLOB_TABLE and the BLOB column is called PHOTO.

    Run:

    Code:
    select DBMS_LOB.GETLENGTH(PHOTO) from BLOB_TABLE;
    If there is data, then the integer returned will be a big number.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    Muchas gracias Julian!

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