Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> create CSV with CLOB
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