(OT) How to append some text to a CLOB field in oracle database without actually replacing what was before.

bkrishnach has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I have a serious problem actually i have history in one of the tables and it is a CLOB datatype and i need to append some text without actually replacing what was there before in oracle database? Please help me out.

2006-08-03 Retitled by planetscape, as per Monastery guidelines

( keep:2 edit:7 reap:7 )

Original title: 'How to append some text to a CLOB field in oracle database without actually replacing what was before.'

Comment on (OT) How to append some text to a CLOB field in oracle database without actually replacing what was before.

Replies are listed 'Best First'.
Re: (OT) How to append some text to a CLOB field in oracle database without actually replacing what was before. by McDarren (Abbot) on Aug 03, 2006 at 03:12 UTC
~~I think you mean "BLOB", and~~ this is hardly a Perl question. I'd suggest that you consult your Oracle documentation, in particular the UPDATE command. You probably want something like: `UPDATE foo SET bar = bar + baz WHERE bar = 'quux';` [download] Or maybe you need to use CONCAT - I'm not sure. Anyway, this is not the forum for this type of question. Update: - well, it turns out there is a CLOB datatype after all. My mistake, and my apologies. And thanks gellyfish for setting me straight :)	[reply] [d/l]
Re^2: (OT) How to append some text to a CLOB field in oracle database without actually replacing what was before. by gellyfish (Monsignor) on Aug 03, 2006 at 07:43 UTC
No I think he really did mean CLOB. The OP probably wants to see this in the DBD::Oracle manpage. /J\	[reply]