Home » SQL & PL/SQL » SQL & PL/SQL » update blob field
update blob field [message #317658] Fri, 02 May 2008 05:24 Go to next message
pranavchati
Messages: 1
Registered: May 2008
Location: pune
Junior Member
I have to update Blob datatype field.
I have some text files stored in the blob and i have to rename a word "index" with "catalog" present in each file. For this i have to write a Procedure so that the changes can be done for all files stored in Blob field.
Re: update blob field [message #317661 is a reply to message #317658] Fri, 02 May 2008 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ text should be store in CLOB not BLOB
2/ Do it, not a problem for you as you are an expert.

Regards
Michel
Re: update blob field [message #317663 is a reply to message #317661] Fri, 02 May 2008 06:11 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use DBMS_LOB.SUBSTR and DBMS_LOB.INSTR.

If you're on 10g, REGEXP_REPLACE supports CLOBS (but not BLOBS)
Previous Topic: ORA-01002
Next Topic: Network location for external table's file
Goto Forum:
  


Current Time: Tue Dec 06 16:32:03 CST 2016

Total time taken to generate the page: 0.09727 seconds