Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev

jamesravid

 Profile Answers by jamesravid 

• Dec 12th, 2006

 

use "sql loader" to limport flat file data to database tables.

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 6th, 2007

 

Hi,

  write a control file to dump the data from file to table using SQL*LOADER or use UTL_FILE to do the same.