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
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: 63911
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.

Re: update blob field [message #317663 is a reply to message #317661] Fri, 02 May 2008 06:11 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member

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: Sat Oct 22 03:49:50 CDT 2016

Total time taken to generate the page: 0.07485 seconds