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

Home -> Community -> Usenet -> c.d.o.server -> create CSV with CLOB

create CSV with CLOB

From: zeb <thierry.constant1_at_free.fr>
Date: Mon, 7 Oct 2002 21:50:00 +0200
Message-ID: <3da1e449$0$32433$626a54ce@news.free.fr>


Hi,

I want to create a CSV file from a table where a column is a CLOB so I use concatenation , I have the following error:

select exp||';'||bresoc||';'||';'||resume||';'||coddos from table_name

          *
ERROR at line 1:
ORA-00932: inconsistent datatypes

How can I do that ?

Thanks in advance

Oracle 8.1.7
HP-UX 11.0 Received on Mon Oct 07 2002 - 14:50:00 CDT

Original text of this message

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