SQL*Loader – Loading Data from Data Files
In this tutorial you will learn about SQL*Loader – Input Data and Datafiles, Fixed Record Format, Variable Record Format and Stream Record Format. SQL*Loader is useful when you need to load the files in batch mode. SQL* Loader supports three different type of data files. You will need to specify the “INFILE” parameter with the file format and additional parameters required. Fixed Record Format: This format is useful when you have a data file with fixed layout. Variable Record Format: This format is used when you have different record lengths…
Read More