You can easily produce it by yourself. Use UTL_FILE package for IO and
cursor to retrieve data from table.

KAzi

Robert Akonji wrote:
> I want to get data from these fields from the database with table_name
> tranformation(person_id,
> Process_id,
> Method_Nm,
> Argnt,
> Method_At,
> Start_dtme,
> End_dtm,
> text_info;) into a text file weller.txt
>
> and also
>
> use the same text file(weller.txt) to load into table creature(person_id,
> Process_id,
> Method_Nm,) with these fields using sequence to generate the
> person_id
>
> thanks
>
> Bob
>
> The information transmitted is intended only for the person or entity
to which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender
and delete or destroy the material/information.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


Oracle LazyDBA home page