All
I have flatfile, in the flat file columns comine like this.
1~emp|2~ename|3~sal|
100|sam|1000
101|raj|2000
103|steve|3000
How to read and write this file into oracle table.
Please provide the solution.
Thanks
Raji
How to read tilde(~) column in sequential file
Moderators: chulett, rschirm, roy
What have you tried so far? What issues are you having?
On the surface, it's just a pipe-delimited file which shouldn't really provide any challenges in the reading dept. I'm assuming that first record is the header row and can be skipped. If there's more to this than meets the eye, please clarify for us what that might be.
On the surface, it's just a pipe-delimited file which shouldn't really provide any challenges in the reading dept. I'm assuming that first record is the header row and can be skipped. If there's more to this than meets the eye, please clarify for us what that might be.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers