vendredi 3 janvier 2020

Extract data from pattern in oralce

Can any one guide me how to extract data from clob in oracle. My data is like this:

{4:
:20:61668
:21:LVTS Balance
:32A:061020CAD5257264,85
:52A:BCANCAW2
:57J:/ABIC/CHARER33
/ADD1/8TH AVENUE/ADD2/LOS ANGELES
:58A:/0332313
CIBCCATT
-}

Now my requirement is to extract value CHARER33 in my output. Can some one assist me.

Thanks

Aucun commentaire:

Enregistrer un commentaire