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

Thread: Querying a BLOB column

  1. 08-23-2005, 07:14 AM #1
    Chucks_k
    Chucks_k is offline Senior Member
    Join Date
    Dec 2001
    Posts
    337

    Querying a BLOB column

    Hi all,

    I have a need to identify certain characters in col marked as type BLOB. After some research i saw the package dbms_lob surface quite a few times. Is this the best way to do it?. If so, does anyone have an idea of what methods to use inorder to identify the certain characters i am looking for in the BLOBS. Lastly, once these characters have been identified then is there a way where i can manipulate the BLOB to substitute the characters to something else?

    Thanking u in advance,
    Chucks
    Reply With Quote Reply With Quote
  2. 08-24-2005, 05:14 AM #2
    stancho
    stancho is offline Junior Member
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    You should use dbml_lob together with utl_raw, that way it will be easier to find and manipulate the characters in question
    Reply With Quote Reply With Quote
  3. 08-25-2005, 01:15 PM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Look for a character in binary (BLOB) col?


    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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