用于创建 Oracle SQL Loader 控制文件的用户界面
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/118367/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
User Interface for creating Oracle SQL Loader control file
提问by JoshL
Is there a good user interface for authoring Oracle SQL Loader control files? PL/SQL Developer includes a "Text Importer" feature (that reminds one of the Excel import wizard) to import text files into tables, but uses a proprietary format instead of the SQL Loader format. Something like this for the SQL Loader format would be quite helpful.
是否有用于编写 Oracle SQL Loader 控制文件的良好用户界面？PL/SQL Developer 包括一个“文本导入器”功能（它提醒 Excel 导入向导之一）将文本文件导入表中，但使用专有格式而不是 SQL 加载器格式。对于 SQL Loader 格式，这样的东西会很有帮助。
回答by cagcowboy
TOAD has an interface to do SQL*Loads, it can generate the control files too...
TOAD 有一个接口来做 SQL*Loads，它也可以生成控制文件......
回答by JoshL
The TOAD answer is probably the best at present. However, in trying out the TOAD SQL Loader wizard, I was disappointed at the level of usability. It assumed that I had a pre-existing table to load the data into. I was looking for something that would let me first
TOAD 的答案可能是目前最好的。然而，在尝试 TOAD SQL Loader 向导时，我对可用性级别感到失望。它假设我有一个预先存在的表来加载数据。我一直在寻找能让我先行的东西
- locate columns in the fixed-width input file, then
- analyze the columns for candidate names and data types, then
- generate a table andcontrol file for loading the data
- 在固定宽度的输入文件中定位列，然后
- 分析候选名称和数据类型的列，然后
- 生成用于加载数据的表和控制文件
Since I couldn't find anything that would adequately meet my needs, I created a utility for the purpose. The utility is somewhat custom to my specific needs (fixed-width file format, headers on top, dashed divider separating headers from data, white space between columns) and only supports the SQL Loader features that I required. If I have opportunity to flesh it out to something more universally usable, I'd be happy to post it for the community.
由于我找不到可以充分满足我需求的任何东西，因此我为此创建了一个实用程序。该实用程序有点针对我的特定需求（固定宽度的文件格式、顶部的标题、将标题与数据分开的虚线分隔线、列之间的空白）并且仅支持我需要的 SQL 加载程序功能。如果我有机会将其充实为更普遍可用的东西，我很乐意将其发布给社区。
