RE: LONG columns - question

why not tis..
SQL> select long_col, ',', another_column from table; or you can select double quotes also as another column...!!

Rahul;

> ----------
> From: Abdul Aleem[SMTP:abchaudhary-ho_at_beaconhouse.edu.pk ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: 04 Mei 2000 15:43
> To: Multiple recipients of list ORACLE-L
> Subject: RE: LONG columns - question
>
> I am not sure, but may be you could try with datatype conversion functions
>
> Aleem
>
> -----Original Message-----
> Sent: 04 May, 2000 12:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
>
> 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?
>
> --
> Author: Abdul Aleem
> INET: abchaudhary-ho_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu May 04 2000 - 05:24:22 CDT