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: [EMAIL PROTECTED]
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@i-Commerce Services" <[EMAIL PROTECTED]> 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@i-Commerce Services
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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@i-Commerce Services
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).