它不是完全复制和粘贴的，但是您可以使用Oracle SQL Developer从Excel导入数据.

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

导航至要将数据导入到的表，然后单击Data选项卡.

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

点击数据标签后，您应该注意到一个下拉菜单，显示Actions...

After clicking on the data tab you should notice a drop down that says Actions...

点击Actions...并选择底部选项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 :

1. 选择创建表的SCHEMA.(从左侧窗格的连接"选项卡中选择).
2. 右键单击SCHEMA，然后选择SCHEMA BROWSER.
3. 从列表中选择表(通过提供架构).
4. 现在，您将看到DATA选项卡.
5. 单击Actions和Import Data...

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