+ Reply to Thread
Results 1 to 3 of 3

Thread: viewing BLOB

  1. 07-05-2002 02:43 AM #1
    jamoji
    jamoji is offline Member
    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
    Reply With Quote Reply With Quote
  2. 07-05-2002 03:24 AM #2
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 07-05-2002 03:32 AM #3
    jamoji
    jamoji is offline Member
    Join Date
    Jan 2002
    Posts
    152
    Muchas gracias Julian!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width