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?

July 07, 2008 00:32:05	#4
ajaz_11i	Member Since: June 2008 Total Comments: 4
RE: how to add data from excel sheet to oracle database?
Save the excel data as .cvs file or in notepad file each field is seperated by comma. then use either SQL Loader, or UTL_FILE Package, & or External Table..... By Mr. Ajaz Ahmad Kumar