Try use PL/SQL Block with DBMS_OUTPUT:
SET SERVEROUTPUT ON SIZE 100000
DECLARE
CURSOR c_cursor IS
SELECT long_type_column, varchar2_type_column FROM tab1;
BEGIN
FOR c_row IN c_cursor LOOP
DBMS_OUTPUT.PUT_LINE('INSERT INTO TAB2 VALUES (''' ||
c_row.long_type_column ||
''', ''' || c_row.varchar2_type_column || ''');');
END LOOP;
END;
/
Just curious, cannot you use EXP/IMP utilities or COPY command for what you are
trying to accomplish?
HTP.
Gunawan Yuwono
- "Johan Locke_at_i-Commerce Services" <Johan.Locke_at_za.didata.com> wrote:
> 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).
Gunawan Yuwono
Oracle DBA
Kansas City, USA
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices!
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gunawan Yuwono
INET: gyuwono_at_yahoo.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 Thu Feb 22 2001 - 02:42:19 CST
