Re: How to concatinate a clob with a varchar2?
From: dave mausner <dmausner_at_ameritech.x.net>
Date: Thu, 27 Jan 2000 02:29:18 GMT
Message-ID: <8EC7DB44Bdlm_at_206.141.192.241>
Date: Thu, 27 Jan 2000 02:29:18 GMT
Message-ID: <8EC7DB44Bdlm_at_206.141.192.241>
joeph_at_altavista.com (Joep Hendrix) wrote in <0E16861EE7BCD111BE9400805FE6841F0DF510BD_at_c1s5x001.cor.srvfarm.originit. com>:
>What I would like to do is to concatinate clob values with varchar2
>like:
>select long_text || 'some string'
>from table_name;
you cannot do it from SQL because there are no built-in functions of LOBs. In PL/SQL you could write a procedure to read the last piece of a LOB into a varchar string, perform the concat the usual way, then perform a piecewise update of the LOB. a nice challenge.
-- dave mausnerReceived on Thu Jan 27 2000 - 03:29:18 CET