Skip to Main Content

SQL & PL/SQL

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!

Import and create table from text file

1049879Mar 26 2015 — edited Mar 26 2015

Hello guys,

I have a text file. It contains a text table that includes 6 columns. How can I import it into Oracle database. This is how the information appears in the text file.

82262014-05-29 06:51:108010
81372014-05-29 06:51:188010
91082014-05-29 06:54:188010
81802014-05-29 06:57:158010
2722014-05-29 07:01:528010
4802014-05-29 07:02:008010
92032014-05-29 08:06:208010
83482014-05-29 08:08:598010
5952014-05-29 08:09:038010
82242014-05-29 08:11:328010
2952014-05-29 08:11:458010
5602014-05-29 08:13:058010
91812014-05-29 08:14:09801

0

Is there any way to import this file into my table ?

I also want to use it in a button in my form builder 6i.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2015
Added on Mar 26 2015
6 comments
1,723 views