Re: Data Export

From: Svend Jensen <Svend.S.Jensen_at_it.dk>
Date: Thu, 17 Jul 2003 21:31:58 +0200
Message-ID: <3f16f9a3$0$32446$edfadb0f@dread16.news.tele.dk>

Pierre wrote:

> I have the following table:
>
> create table t (
> t1 varchar2(35),
> t2 varchar2(35),
> t3 varchar2(35));
>
> And I insert into this table the following values:
>
> insert into t values ('X1','X2','X3');
>
> I need to export it as a flat file in which each record should be in
> the insert data format, e.g. insert into t values ('X1','X2','X3');
>
> I found an option in TOAD which can provide me this format.
> Ufortunately I need it to run independently.
>
> Regards,
> Pierre

Create it as:
set pages 0
set heading off
......
spool inserts.sql
select 'insert into ......

values( ''''||t1||''''||','||.................... ||';'

from t ;
spo off
@inserts

/Svend Received on Thu Jul 17 2003 - 14:31:58 CDT