Home » RDBMS Server » Server Utilities » How to Read Data from Notepad/file and insert to the Database 10g
How to Read Data from Notepad/file and insert to the Database 10g [message #271077] Sat, 29 September 2007 01:12 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear Experts,

There is a notepad named attn.txt and it contails the following data:


ID Date InTime OutTime
---- ----- ------ ---------
001 12-SEP-2007 8:20:15 AM 6:21:18 PM
002 12-SEP-2007 8:21:15 AM 6:22:18 PM
003 12-SEP-2007 8:22:15 AM 6:22:18 PM
004 12-SEP-2007 8:23:15 AM 6:23:18 PM
005 12-SEP-2007 8:24:15 AM 6:24:18 PM
006 12-SEP-2007 8:25:15 AM 6:24:18 PM
007 12-SEP-2007 8:26:15 AM 6:26:18 PM
008 12-SEP-2007 8:27:15 AM 6:27:18 PM
009 12-SEP-2007 8:27:28 AM 6:29:18 PM

my question, how can i insert this data to my database 10g?
In my database there is a table named EmpAttn and its structure as follows:

EmpAttn
-------
EmpID Number(20) PK
AttnDate Date
InTime -do-
OutTime -do-

Please Help me.

Kamal Hossain
Dhaka,Bangladesh
Re: How to Read Data from Notepad/file and insert to the Database 10g [message #271090 is a reply to message #271077] Sat, 29 September 2007 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd use external table feature or SQL*Loader.
Re: How to Read Data from Notepad/file and insert to the Database 10g [message #271107 is a reply to message #271077] Sat, 29 September 2007 09:24 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition,
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Character Set ID(2000)?
Next Topic: Methods to move data between databases
Goto Forum:
  


Current Time: Wed Dec 07 12:31:27 CST 2016

Total time taken to generate the page: 0.24010 seconds