| Import and create table from a text file [message #635382] |
Sun, 29 March 2015 01:14  |
 |
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
|
Senior Member |
|
|
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.
8226 2014-05-29 06:51:10 8 0 1 0
8137 2014-05-29 06:51:18 8 0 1 0
9108 2014-05-29 06:54:18 8 0 1 0
8180 2014-05-29 06:57:15 8 0 1 0
272 2014-05-29 07:01:52 8 0 1 0
480 2014-05-29 07:02:00 8 0 1 0
9203 2014-05-29 08:06:20 8 0 1 0
8348 2014-05-29 08:08:59 8 0 1 0
595 2014-05-29 08:09:03 8 0 1 0
8224 2014-05-29 08:11:32 8 0 1 0
295 2014-05-29 08:11:45 8 0 1 0
560 2014-05-29 08:13:05 8 0 1 0
9181 2014-05-29 08:14:09 8 0 1 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.
[Updated on: Sun, 29 March 2015 01:23] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Import and create table from a text file [message #635390 is a reply to message #635388] |
Sun, 29 March 2015 08:48  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As you mentioned Forms 6i (which is, I presume, client-server application - unless you deployed it on web), then the file is on your PC. Furthermore, it means that SQL*Loader is an option which would work.
First develop SQL*Loader part of the story - create a control file and make sure it successfully & correctly loads data into a table. Put SQLLDR command line into a batch file. Finally, the HOST built-in will be used in a WHEN-BUTTON-PRESSED trigger and call previously created batch file (which will, in turn, load data into a table).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
