Quote:
Originally Posted by
ramkumar15
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records.
Connect to the schema where you have your table to be populated.
Click on the connection name, then Tables in the left pane.
Right click on the table which you intend to populate.
Left click on Import Data... (Doing this opens up a file explorer window.)
Navigate to your Excel spreadsheet, select it and click Open.
This opens up the Data Import Wizard. Keep selecting the options you want (depending on what you have in your Excel file and what you want in the table), and clicking Next till you reach the last page.
Then click Finish.
It will then load the data from Excel spreadsheet to your database table.