Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to insert data from file to table??

ShailendraNaginaDec 11 2012 — edited Dec 19 2012
I need to know that how can i insert data in multiple column through file. I can simply insert data in one column table but couldnt find out the way to put data in all column.

My data store in a file
************************************************text.txt***************
133, shailendra, nagina, 14/H, 45637, 9156729863

**************************************************************my_data(table)**********
trying to insert into below table...

id, name, last_name, add, pin. mob

*********************************************

Let me know if anything else needed..:)
This post has been answered by Gary Graham-Oracle on Dec 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2013
Added on Dec 11 2012
4 comments
523 views