Loading Data > Sql loader options
  
Sql loader options
Oracle only. Allows the entry of both SQL*Loader options and a 'When' statement. If both options and a when statement are used then the when statement must follow the options. (e.g. options (direct=true,parallel=true) when product_code = '02' ).
Note: There are some limitations on the 'When statement'. At the time of writing the not symbol (!) will not work for a Windows based load but will work under UNIX.