Re: Data Export - Urgent Training

pierre.olaru_at_citicorp.com (Pierre) wrote

> create table t (
> t1 varchar2(35),
> t2 varchar2(35),
> t3 varchar2(35));

<snipped>
> 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');

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