Top "Controlfile" questions

SQL Loader script help with adding SYSDATE, USER

I'm trying to load data from a file and I want to set CREATED_DATE and UPDATED_DATE to SYSDATE …

Read More
sql oracle csv sql-loader controlfile
Can variables be passed to a SQL*Loader control file via sqlldr command?

Below is my Control file example : OPTIONS (skip=1,errors=1000,direct=true,rows=10000) load data append into table TABLE_NAME fields …

Read More
oracle sql-loader controlfile
How to use the OR condition in when clause of SQL Loader control file

I am trying to use the OR condition in when clause in control file, This this my code in control …

Read More
sql-server sql-loader ctl controlfile