Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to concatinate a clob with a varchar2?
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