try to use append which is providded by Oracle.
Joep Hendrix <joeph_at_altavista.com> wrote in message
news:0E16861EE7BCD111BE9400805FE6841F0DF510BD_at_c1s5x001.cor.srvfarm.origin-it
.com...
> Hi everebody,
>
> This is my table:
> create table table_name
> ( id number
> , long_text clob);
>
> What I would like to do is to concatinate clob values with varchar2
> like:
> select long_text || 'some string'
> from table_name;
>
> Ho can I achieve this?
>
> Thanks in advance,
>
> Joep
>
>
Received on Wed Jan 26 2000 - 22:51:38 CST
