generate data from a table into a text file and loading from the file into a table

generate data from a table into a text file and loading from the file into a table

 

  


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.

Oracle LazyDBA home page