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

"Pierre" <pierre.olaru (AT) citicorp (DOT) com> schrieb im Newsbeitrag
news:5e0672c6.0307162259.44136d18 (AT) posting (DOT) google.com...
Hi Pierre,

do you mean something like:
select
'insert into t values ('''||sysdate||''','''
from dual;

Just modify the example to fit your needs.

hth,
Guido

pierre.olaru (AT) citicorp (DOT) com (Pierre) wrote

Standard SQL outputting data in CSV format:
SELECT
t1||','||t2||','||t3
FROM t

Spool to file (e.g. using something like SQL*Plus).

You also may want to enclose character columns with double quotes.

Alternatively, you may want to consider using Oracle's Export and Import utilities.

--
Billy