Data Export - Urgent question

[pierreo]

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 from Toad.

Regards,
Pierre

 

[alexhu]

spool <filename>
select * from t;
spool off

(or maybe I don't understand your question? )

Alex

 

[JohnMeli]

spool <filename>
select 'insert into t values
('||''''||t1||''''||','||''''||t2||''''||
','||''''||t3||''''||');' from t;
spool off

This will create the <filename> file in which
you will find the script for the creation of
all the records of t.

I hope this helps

John

 

[alexhu]

Ah now I see

Thats why I'm not a programmer !

Alex