Answer Detail: RE: how to add data from excel sheet to oracle database?

GeekInterview.com > Interview Questions > Oracle > Data Access

Print |

Question: how to add data from excel sheet to oracle database?

September 09, 2008 06:02:58	#6
ritikaag2002	Member Since: September 2008 Total Comments: 1
RE: how to add data from excel sheet to oracle database?
it can be inserted using insert statement : ="insert into R1 values('"&A2&"','"&B2&"','"&C2&"','"&D2&"','"&E2&"','"&F2&"','"&G2&"',"&H2&",'"&I2&"','"&J2&"','"&K2&"','"&L2&"','"&M2&"',"&N2&","&O2&",to_char("&P2&",mm/dd/yy);" into excel sheet against each row. It will automaticaly create insert query for the data n a particular table and that insert script can be run on ql prompt.....