How copy data from Excel to a table using Oracle SQL Developer

Question

Is there any alternative way to copy the data from Excel sheet and paste it into a table using Oracle SQL Developer!?

For now I am using (PL/SQL Developer) by writing (for update) at the end of the select statement, Ex:

Select * from ABD
for update

Then paste the columns from Excel to the table...

Regards Adel

mahi_0707 · Accepted Answer · 2017-11-03 11:59:04Z

26

It's not exactly copy and paste but you can import data from Excel using Oracle SQL Developer.

Navigate to the table you want to import the data into and click on the Data tab.

After clicking on the data tab you should notice a drop down that says Actions... indicating the position of the Data tab and Actions... drop down

Click Actions... and select the bottom option Import Data...

Then just follow the wizard to select the correct sheet, and columns that you want to import.

EDIT : To view the data tab :

Select the SCHEMA where your table is created.(Choose from the Connections tab on the left pane).
Right click on the SCHEMA and choose SCHEMA BROWSER.
Select your table from the list (by giving your schema).
Now you will see the DATA tab.
Click on Actions and Import Data...

edited Nov 3, 2017 at 11:59

mahi_0707

1,0629 silver badges17 bronze badges

answered Nov 23, 2011 at 12:55

Chris Kent

88111 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Junchen Liu Over a year ago

still have to pre define the columns... very annoy

Nikita Silverstruk · Accepted Answer · 2013-07-10 18:15:43Z

4

None of these options show up for me. The way to paste data from Excel is as follows:

Add an extra column to the left of your spreadsheet data (if you don't have row numbers showing in PL/SQL Developer you may not have to have an extra empty column to the left).
Copy the rows of data from your spreadsheet including the empty column.
In PL/SQL Developer, open your table in edit mode. You can right-click the table name in the object browser and select Edit Data or write your own select statement that includes the rowid and click the lock icon. Be sure your columns are ordered the same as in your spreadsheet.
Here's the part that took me forever to figure out: click on the left side of the first empty row to highlight it. It will not work if you don't have the first empty row highlighted.
Paste as usual using Ctrl+V or right-click Paste.

I couldn't find this info anywhere when I needed it, so I wanted to be sure to post it.

edited Jul 10, 2013 at 18:15

Nikita Silverstruk

1,1171 gold badge20 silver badges42 bronze badges

answered Jul 10, 2013 at 17:46

Quaint88

412 bronze badges

1 Comment

mahi_0707 Over a year ago

Please see the above edited answer for viewing DATA tab

Vaibhav Misra · Accepted Answer · 2012-06-26 07:50:24Z

1

You may directly right-click on the table name - that also shows the "Import Data.." option.Then you can follow few simple steps & succeed.

Do anyone know how to import a new table with data from excel?

answered Jun 26, 2012 at 7:50

Vaibhav Misra

111 bronze badge

1 Comment

j0k Over a year ago

You should ask a new question instead of a question inside an answer.

TomD · Accepted Answer · 2013-03-26 16:26:55Z

1

Click on "Tables" in "Connections" window, choose "Import data ...", follow the wizard and you will be asked for name for new table.

answered Mar 26, 2013 at 16:26

TomD

112 bronze badges

Comments

Kumarakuru · Accepted Answer · 2014-09-17 05:04:11Z

-1

For PLSQL version 9.0.0.1601

From the context menu of the Table, choose "Edit Data"
Insert or edit the data
Post change

answered Sep 17, 2014 at 5:04

Kumarakuru

1

Collectives™ on Stack Overflow

How copy data from Excel to a table using Oracle SQL Developer

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related