17.5.1 CSV format specifications
In CSV format, item data is separated by delimiters. The delimited item data is called field data. The following figure shows an example of the CSV format.
- Explanation:
-
-
Each row of data in an input data file corresponds to a row of data in the table.
-
The field data items to be entered in the input data files need not be in the same order in which the columns appear in the table.
-
Use the character encoding specified in the ADBLANG environment variable to create the input data file.
-
If field data is enclosed in enclosing characters, specify the enclosing character in the -k option of the adbimport command.
-
Demarcate the field data items with a delimiter. Specify this delimiter in the -s option of the adbimport command.
-
Use the same format as for character string data to represent numeric values, such as age.
-