RE: LONG columns - question

Hi all,

  Even when we attempt to dump the details in ASCII format, please   remember that the contents in a LONG field can also contain linefeeds.

  You may land up having the column value spanning across more than one   line with or without linefeeds. (If I am right, a LONG column can   store upto 2Gig of data)

  If you are planning to use the file to re-load then you may encounter   issues while doing so.

  just a thought...

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: Rahul <rahul_at_ratelindo.co.id>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: LONG columns - question
Date: Thu, 04 May 2000 03:48:33 -0800

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).
>

--
Author: Rahul
   INET: rahul_at_ratelindo.co.id

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).

________________________________________________________________________