Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to concatinate a clob with a varchar2?

How to concatinate a clob with a varchar2?

From: Joep Hendrix <joeph_at_altavista.com>
Date: Tue, 25 Jan 2000 22:16:54 +0100
Message-ID: <0E16861EE7BCD111BE9400805FE6841F0DF510BD@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 Tue Jan 25 2000 - 15:16:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US