SQL * Loader
CHAPTER 9-SQL * Loader v SQL*Loader allows you to load data from an external file into a table in the database. It can parse many delimited file formats such as CSV, tab-delimited, and pipe-delimited. v Method 1 by using par file in command prompt v We will load email data CSV file format into the emails table in the database. v The following is the content of the email.dat file: 1, john.doe@example.com 2, jane.doe@example.com 3, peter.doe@example.com v The contents of the control file ( email.ctl ) is as follows: load data into table emails insert fields terminated by "," ( email_id, email ) In the control file: The load data into table emails insert instruct the SQL*Loader to load data into the emails table using the ...