options ::=

OPTIONS
(
BINDSIZE = n
COLUMNARRAYROWS = n
DATE_CACHE = n
DEFAULTS = {IGNORE| EVALUATE_ONCE | EVALUATE_EVERY_ROW | IGNORE_UNSUPPORTED_EVALUATE_ONCE | 
IGNORE_UNSUPPORTED_EVALUATE_EVERY_ROW}
DEGREE_OF_PARALLELISM = {degree_num | DEFAULT | AUTO | NONE}
DIRECT = {TRUE | FALSE}
DIRECT_PATH_LOCK_WAIT = {TRUE | FALSE}
EMPTY_LOBS_ARE_NULL = {TRUE | FALSE}
ERRORS = n
EXTERNAL_TABLE = {NOT_USED | GENERATE_ONLY | EXECUTE}
FILE = tablespace file
LOAD = n
MULTITHREADING = {TRUE | FALSE}
PARALLEL = {TRUE | FALSE}

)