If you plan to load data using external tables, there are
numerous table format options that you can use to help control how
the data is processed during the load.
External table options
When you create an external table definition, you can specify
options that control processing for records, fields, and for the load
operation itself. There are different types of options: some are for
records/rows, some are for fields, and some are for loads. Use these
options when loading from an external table or when using the external
table directly in a SQL query.