如何使用Oracle SQL Developer将数据从Excel复制到表 [英] How copy data from Excel to a table using Oracle SQL Developer

问题描述

是否有其他方法可以使用Oracle SQL Developer从Excel工作表中复制数据并将其粘贴到表中?！

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

目前，我正在使用(PL/SQL Developer)，方法是在select语句(例如:)的末尾写(用于更新):

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

然后将Excel中的列粘贴到表格中...

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

问候 阿德尔

推荐答案

它不是完全复制和粘贴的，但是您可以使用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...

这篇关于如何使用Oracle SQL Developer将数据从Excel复制到表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！