Re: How to concatinate a clob with a varchar2?

joeph_at_altavista.com (Joep Hendrix) wrote in <0E16861EE7BCD111BE9400805FE6841F0DF510BD_at_c1s5x001.cor.srvfarm.origin- it.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 mausner Received on Wed Jan 26 2000 - 20:29:18 CST