| update blob field [message #317658] |
Fri, 02 May 2008 05:24  |
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  |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
JRowbottom
Messages: 2663
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)
|
|
|
]
Members
Search
Help
Register
Login
Home
