Hay

dbms_lob.substr(lob_loc,dbms_lob.instr(lob_loc,'<BF_NOWAIT>' + 11,dbms_lob.instr(lob_loc,'</BF_NOWAIT>' - 11-dbms_lob.instr(lob_loc,'<BF_NOWAIT>' )

-----Original Message-----
From: Sreedhar_Bhaskararaju [mailto:oracledba-ezmlmshield-x97257616.[Email address protected]
Sent: ה 01/12/2005 15:18
To: LazyDBA Discussion
Cc:
Subject: How do I get text between two strings from CLOB



Hi All,



assume clob db contains an xml file,



<?xml version = '1.0'?>

<?xml-stylesheet type='text/xsl' href='TEST_EFFPER.xsl' ?>

<Instance_info>

<table num="1">

<BF_NOWAIT>100</BF_NOWAIT>

<BF_NOWAIT_MSG> </BF_NOWAIT_MSG>

<RD_NOWAIT>100</RD_NOWAIT>

</table>

</Instance_info>



How do I get data between two strings <BF_NOWAIT> and </BF_NOWAIT>?



Any ideas please?



Thanks in advance,

Sree



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page