如何在 Oracle sqlldr 控制文件中指定制表符分隔文件加载？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3527913/
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
How to specify tab delimitation file load in Oracle sqlldr control file?
提问by Jé Queue
This should be simple, but what is the correct syntax for an Oracle sqlldr control file in order to specify tab delimited/separated data?
这应该很简单，但是为了指定制表符分隔/分隔数据，Oracle sqlldr 控制文件的正确语法是什么？
FWIW, I found the file was UTF16 and not UTF8, and was editing fine but would introduce null bytes as Oracle read the control file. Can't even replicate today.
FWIW，我发现该文件是 UTF16 而不是 UTF8，并且编辑得很好，但会在 Oracle 读取控制文件时引入空字节。今天甚至无法复制。
回答by Alex Martelli
Per this thread, it should be fields terminated by '\t'(don't have an Oracle installation at hand to verify that this is correct).
根据这个线程，它应该是fields terminated by '\t'（手头没有 Oracle 安装来验证这是正确的）。
