Oracle provides SQL Loader (SQLLDR) for loading data in delimited text format.
Oracle提供sqlLoader (sqlldr)用于装载分界文本格式的数据。
Data for all cached tables is kept in a file named database.data, while text table data is kept in any delimited text file (like CSV files) named by the set table source non-standard SQL statement.
所有缓存表的数据放在一个名为database . data的文件中，而文本表的数据则放在由settablesource非标准sql语句命名的任意分隔文本文件(像CSV文件)中。
The stored procedure in Figure 6 accepts the text of an entire comma-delimited file containing up to 2gb of Unicode data.
图6中的存储过程接受包含最多2gbUnicode数据的以逗号分隔的文件的整个文本。
A row of data in a delimited text file does not have the expected number of fields.
分隔的文本文件中的数据行不具有预期的字段数。
Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column).
带分隔符的数据无效：文本限定符后必须跟一个列分隔符(最后一列除外)。
Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column).
带分隔符的数据无效：文本限定符后必须跟一个列分隔符(最后一列除外)。
应用推荐