-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|