OraFAQ Forum: Server Utilities » How to Read Data from Notepad/file and insert to the Database 10g

Home » RDBMS Server » Server Utilities » How to Read Data from Notepad/file and insert to the Database 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Read Data from Notepad/file and insert to the Database 10g [message #271077]

Sat, 29 September 2007 01:12

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

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd use external table feature or SQL*Loader.

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 09:55:56 CST 2024