OraFAQ Forum: Forms » insert data ta table from file

Home » Developer & Programmer » Forms » insert data ta table from file

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

insert data ta table from file [message #87184]

Mon, 13 December 2004 02:29

S. Sathish Kumar
Messages: 11
Registered: October 2004

Junior Member

i have a table and a text file. I want to insert the datas into the table(temp_tab) from the file(data.txt)

How to to this, i have given example table and text file

create table temp_tab(sno number,
cus_name varchar2(100));

data.txt

1 sathish
2 nataraj

With regards

S. Sathish Kumar

Report message to a moderator