Load the data into Oracle database using SQL Loader
Load the data into Oracle database using SQL Loader- SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. It supports various load formats, selective loading, and multi-table loads. OR SQL*Loader is a command line utility, provided by Oracle to load data from external files into Oracle database. Note- We can only insert the data into target tables. In SQL*Loader, during the process of loading data from external file, It needs two input files and generates three output files. Input files- Data File Control File Output files- Log File Bad File Discard File In details- 1. Data File: It is a flat file/external file/source file, which we need to load into database. 2. Control file: Control file defines the structure of a flat file/external file/source file. How the data is formatted in data file, information about target table to load the data etc. Process- SQL Loader reads...