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.
1 Like
thanks durden.
Currently my date format is not accepting in my table.
In excel its there as 23-OCT-14. After importing its converted to 10/23/14.
My table accepts in this format only 23-OCT-14.
Please anyone help me out to sort this issue.
Alter the date format in your spreadsheet. Right click, format cells, select 'number' under custom, in the 'type' field type yyyy/mm/dd
Your issue is not clear as your statements appear to be contradictory.
Were you able to load the data?
"... is not accepting ..." => Was there a problem during load? (Oracle always returns an "ORA-" error code and message in case of problems.)
"... After importing ..." => Was the load was successful? (Partially? Completely?)
Also, what is the datatype of the column where you want to insert 23-OCT-14?