Re: CLOB field question
On Thu, Aug 16, 2001 at 02:15:55AM -0800, Guy Hammond wrote: I have another CLOB question, what is the best way to do a search-and-replace? Something like a c/oldvalue/newvvalue/ on the SQL*Plus command line, or $variable =~ s/oldvalue/newvalue/; in Perl. The only thing I can think of right now would be using INSTR to locate the value I want, SUBSTR to extract the parts of the document either side of it, then APPEND to create a new CLOB with first part, new value, last part... but this seems a bit inelegant. My Oracle::OCI perl modules is close to being able to let you stream a LOB into client memory and stream it back to the server, possibly applying perl regular expressions along the way. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CLOB field question
Bill, How about select id from MyTable where DBMS_LOB.INSTR(YourClobColumn,UPPER(value_to_search_for)) 0 and your_db_version = 8i HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CLOB field question
Raj, Perfect!!! This is just what I needed! Thanks so much. Bill Bill Tantzen University of Minnesota Libraries 612-626-9949 [EMAIL PROTECTED] A computer program will always do what you tell it to do, but rarely what you want it to do. - -Original Message- - From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, - Rajendra - Sent: Wednesday, August 15, 2001 3:35 PM - To: Multiple recipients of list ORACLE-L - Subject: RE: CLOB field question - - - Bill, - - How about - - select id - from MyTable - where DBMS_LOB.INSTR(YourClobColumn,UPPER(value_to_search_for)) 0 - and your_db_version = 8i - - HTH - Raj - __ - Rajendra Jamadagni MIS, ESPN Inc. - Rajendra dot Jamadagni at ESPN dot com - Any opinion expressed here is personal and doesn't reflect that - of ESPN Inc. - - QOTD: Any clod can have facts, but having an opinion is an art ! - - *1 - - This e-mail message is confidential, intended only for the named - recipient(s) above and may contain information that is - privileged, attorney work product or exempt from disclosure - under applicable law. If you have received this message in - error, or are not the named recipient(s), please immediately - notify corporate MIS at (860) 766-2000 and delete this e-mail - message from your computer, Thank you. - - *1 - - -- - Please see the official ORACLE-L FAQ: http://www.orafaq.com - -- - Author: Jamadagni, Rajendra - INET: [EMAIL PROTECTED] - - Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 - San Diego, California-- Public Internet access / Mailing Lists - - To REMOVE yourself from this mailing list, send an E-Mail message - to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in - the message BODY, include a line containing: UNSUB ORACLE-L - (or the name of mailing list you want to be removed from). You may - also send the HELP command for other information (like subscribing). - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Tantzen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).