script for reading BLOB data

Hi,

this may not be a right place to post my question. But still....

I have database table of which one field contains BLOB data. Actually the BLOB data is xml script.

Now How do I retrieve that xml script to xml file on unix(or windows). I will have to loop thru the records. There are more than 50 records with such BLOB field.

I tried googling around but did not get much help.

Any pointers would help....

Thanks in advance,
-Ashish