RE: LONG columns - question

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Thu, 4 May 2000 12:38:23 +0500
Message-Id: <10487.104903@fatcity.com>

I am not sure, but may be you could try with datatype conversion functions

Aleem

-----Original Message-----
From: Vladimir Barac - posao [mailto:vbarac_at_dkts.co.yu] Sent: 04 May, 2000 12:45 PM
To: Multiple recipients of list ORACLE-L Subject: LONG columns - question

I have encountered some problems regarding long columns in tables - and I have read the manuals (about restrictions), so I was aware of problems. Anyway, workaround will be apreciated.

Here is the situation:

I want to dump content of table to ascii file in format "<column value 1>","<column value 2>",... Note that " and , and <columna value> are concatenated.
using SQL*Plus and spooling and concatenations everything works like charm, except...
LONG column cannot be concatenated (error saying about "incosistent datatypes".

So, what can I do to dump content of a table having long column? Received on Thu May 04 2000 - 02:38:23 CDT