Re: Data Export - Urgent Training

"Pierre" <pierre.olaru_at_citicorp.com> schrieb im Newsbeitrag news:5e0672c6.0307162259.44136d18_at_posting.google.com...
> 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

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 Received on Thu Jul 17 2003 - 02:44:54 CDT