In my oracle database, i had 10 columns in a table out of which 3 columns are also available in a excel file. I want to update the data in oracle table by pulling data from those 3 columns in my excel file.

Please give me sql query to do this in toad.


Yogesh

__________________
Yogesh

Hi Yogesh,

Are you still looking for the solution?

Well I dont know SQL query, but you can pull data into Oracle by
1) first convert excel file into csv file
2) Now by using SQL loader you can load data into the required table.

Hope this will help ;)

Ravi