RE: LONG to char

From: Johan Locke_at_i-Commerce Services <Locke_at_i-Commerce>
Date: Tue, 20 Feb 2001 20:36:11 -0800
Message-ID: <F001.002B9389.20010220202531@fatcity.com>

Hi

I'm attemting to write an insert script for a table:

Spool out.log

SELECT 'INSERT INTO TAB2 VALUES(''' || LONG_TYPE_COLUMN || ''',''' || VARCHAR2_TYPE_COLUMN||''');'
FROM TAB1; spool off

(It moans about Inconsistant Datatypes - which I can understand)

Any ideas on how to get around this?

Regards
JL

-----Original Message-----
Sent: Tuesday, February 20, 2001 5:23 PM To: Johan.Locke_at_za.didata.com

Johan,
What do you exactly want to do? If you could explain it in more detail, I might
be able to help, at least I'll try.

• "Johan Locke_at_i-Commerce Services" <Johan.Locke_at_za.didata.com> wrote:
  > Anybody have any Idee how to conevrt a LONG datatype to char/varchar
  >
  > Regards
  > JL
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Johan Locke_at_i-Commerce Services
  > INET: Johan.Locke_at_za.didata.com
  >
  > 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).
  

  ---

Gunawan Yuwono
Oracle DBA
Kansas City, USA

---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johan Locke_at_i-Commerce Services
  INET: Johan.Locke_at_za.didata.com

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 Tue Feb 20 2001 - 22:36:11 CST