为Oracle生成sql插入-GeneratingsqlinsertintoforOracle

32  

Oracle's free SQL Developer will do this:

Oracle的免费SQL开发人员将这样做:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

You just find your table, right-click on it and choose Export Data->Insert

您只需找到您的表，右键单击它并选择Export Data->Insert

This will give you a file with your insert statements. You can also export the data in SQL Loader format as well.

这将为您提供一个包含insert语句的文件。您还可以以SQL加载程序格式导出数据。

16  

You can do that in PL/SQL Developer v10.
1. Click on Table that you want to generate script for.
2. Click Export data.
3. Check if table is selected that you want to export data for.
4. Click on SQL inserts tab.
5. Add where clause if you don't need the whole table.
6. Select file where you will find your SQL script.
7. Click export.
http://i.stack.imgur.com/lJp9P.png

1  

If you have an empty table the Export method won't work. As a workaround. I used the Table View of Oracle SQL Developer. and clicked on Columns. Sorted by Nullable so NO was on top. And then selected these non nullable values using shift + select for the range.

如果您有一个空表，那么导出方法将不起作用。作为一个解决方案。我使用了Oracle SQL Developer的表视图。和点击列。按Nullable排序，所以NO在上面。然后使用shift + select选择这些非空值。

This allowed me to do one base insert. So that Export could prepare a proper all columns insert.

这允许我做一个基本插入。这样导出就可以准备一个合适的所有列插入。

0  

If you have to load a lot of data into tables on a regular basis, check out SQL Loader or external tables. Should be much faster than individual Inserts.

如果您必须定期将大量数据加载到表中，请查看SQL Loader或外部表。应该比单个插入快得多。

-1  

1. left click on tablename under tables in left pane.
2. 在左窗格中的表下单击tablename。
3. Click on Data tab. here you will see the data present inside the tab.
4. 单击Data选项卡。在这里，您将看到选项卡中显示的数据。
5. Select the data for which you need to create insert queries.
6. 选择需要创建插入查询的数据。
7. Right click on data and click export.
8. 右键单击数据并单击export。
9. Select format as "insert"
10. 选择格式为“插入”
11. Wait for few seconds and your sql script is ready.
12. 等待几秒钟，您的sql脚本就准备好了。

-2  

You can also use MyGeneration (free tool) to write your own sql generated scripts. There is a "insert into" script for SQL Server included in MyGeneration, which can be easily changed to run under Oracle.

您还可以使用MyGeneration(免费工具)编写自己的sql生成脚本。MyGeneration中包含一个SQL Server的“插入”脚本，可以很容易地将其更改为在Oracle下运行。