为Oracle生成SQL插入 [英] Generating sql insert into for Oracle

问题描述

在使用Oracle时，我唯一没有自动化工具的东西是可以创建INSERT INTO脚本的程序.

The only thing I don't have an automated tool for when working with Oracle is a program that can create INSERT INTO scripts.

我并不需要它，所以我不会在上面花钱.我只是想知道是否存在任何可用于在不花费大量资金的情况下为现有数据库生成INSERT INTO脚本的问题.

I don't desperately need it so I'm not going to spend money on it. I'm just wondering if there is anything out there that can be used to generate INSERT INTO scripts given an existing database without spending lots of money.

我在搜索Oracle时没有发现如此功能的运气.

I've searched through Oracle with no luck in finding such a feature.

它存在于PL/SQL Developer中，但是BLOB字段出错.

It exists in PL/SQL Developer, but errors for BLOB fields.

推荐答案

Oracle的免费SQL Developer将执行此操作:

Oracle's free SQL Developer will do this:

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

这将为您提供一个包含插入语句的文件.您还可以导出SQL Loader格式的数据.

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

这篇关于为Oracle生成SQL插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！