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

Thread: extract data from column containg clob

  1. #1
    Join Date
    Aug 2014
    Posts
    1

    extract data from column containg clob

    I have a column in a table that contains a clob. i need to extract data from the clob that starts with "Area=". So for example the clob looks like :
    "LEC=XO, BTN=333-666-1111
    Sourcebook and VoIP Discovery available.
    Area= CapitalMetro, District= Greensboro"

    I just need the info after Area=. so in this case CapitalMetro.
    Please advise/assist
    thanks,
    Mike

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You need to use the DBMS_LOB package for this. There is a instr function as well as a substr function. You probably want some kind of regular expression.

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