Maclean’s Oracle Database Tech Blog Archives
-
SCRIPT TO GENERATE SQL*LOADER CONTROL FILE
This script prepares a SQL*Loader control file for a table already existing in the database. The script accepts the table name and automatically creates a file with the table name and extension ‘ctl’. This is specially useful if you have the DDL statement to create a particular table and have a free-format ASCII-delimited file but…