title: Extract TEXT from a CLOB field
body: <p>I have a CLOB field in my Oracle Database that store TEXT data in the following format:</p>
  
  <pre><code>__99__RU_LOCKED=N;;__99__RU_SUSPENDED=Y;;__17__USER_TYPE=A;;__17__USER_TYPE_610=A;;__17__GUIFLAG=0;;__17__DEFAULT_LANG_610=E;;__17__OUTPUT_DEVICE_46=LOCL;;__17__PRINT_IMMED=G;;__17__DELETE_AFTER_PRINT=D;;__17__CATT=*BLANK;;__17__CATT_46=*;;__17__DEC_FORMAT=*BLANK;;__17__DEC_FORMAT_46=X;;__17__DATE_FORMAT=2;;__17__PARAMETERS=OM_OBJM_NO_DISPLAYX;;__17__MEAS_EASLPFL=0;;__17__USER_GROUP=S1BR22;;__17__VALID_FROM=20080222;;__17__VALID_UNTIL=99991231;;__17__ACCOUNT=37004968;;
  </code></pre>
  
  <p>I'm using TOAD and while I am creating the query I can read the CLOB field with the following:</p>
  
  <pre><code>--- To read the CLOB field.
  select DBMS_LOB.substr(ADD_INFO_MASTER) from USER
  </code></pre>
  
  <p>This select return me the CLOB field HUMAN READABLE.</p>
  
  <p>My question is: Is there any way to extract the one single value like ACCOUNT value from the line above?
  Keep in mind that this CLOB field can variate and the __17__ACCOUNT= will not be in the same place every time. I need a way to extract to locate the ;;__17__ACCOUNT= (this will be a pattern) and extract the the value 37004968.</p>
  
  <p>It is possible to achieve this while performing a query in TOAD?</p>