sql loader Case Study 2: Loading Fixed-Format Fields
Case 2 demonstrates:A separate datafile. See Specifying Datafiles.Data conversions. See Datatype Conversions.In this case, the field positions and datatypes are specified explicitly. Control Fil...
sql loader Case Study 1: Loading Variable-Length Data
Case 1 demonstrates:A simple control file identifying one table and three columns to be loaded.Including data to be loaded from the control file itself, so there is no separate datafile. See Identi...