Hello<

How do I read data from the text file (login_name ,password,mail) and insert it into the table_user.password, table_user.mail fields for each table_user.login_name. Please give me some hints. Thanks a lot!

this really depends on how you want go about doing this. You could simply just create a DTS package and import the text file into the table.

I guess I need to write a script.

what are you wanting to use to do this?

I quess PLSQL. I have bits of code but can't put it together. Sorry.

Sorry, I am in the Microsoft world and have DTS packages to do it, wish I could be more help.

Well thanks anyway

if you are using oracle, I found this article on how to load text files into tables. hope this helps.

http://www.orafaq.org/faqloadr.htm#HOW