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…