Re: How to concatinate a clob with a varchar2?
From: Tom Zamani <tomz_at_redflex.com.au>
Date: Thu, 27 Jan 2000 15:51:38 +1100
Message-ID: <86oilq$g1s$1_at_perki.connect.com.au>
Date: Thu, 27 Jan 2000 15:51:38 +1100
Message-ID: <86oilq$g1s$1_at_perki.connect.com.au>
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 Thu Jan 27 2000 - 05:51:38 CET