How to import text file with fixed length data into a oracle table
856037Jun 22 2011 — edited Jun 22 2011Hi,
I have a txt file with fixed length.
Contents of a file could be:
34 John A.Smith jasmith Engineer
23 Jim P.Johnson jpjohnson Developer
43 Bob D.User bduser King
Lets say
The First 4 characters are: Age
Next 5: First name
Next 2: Middle Initial
Next 8: Last name
Next 10: Username
Last 9: Title.
I have a table... my_table with the fields:
AGE
F_NAME
M_NAME
L_NAME
U_NAME
TITLE
How do I put the data from all of these data files into the table? Any ideas?
and i am using plsql developer. please help.
Edited by: user12288167 on Jun 22, 2011 3:35 AM