Top "Sql-loader" questions

SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database.

Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV …

oracle csv import sqlplus sql-loader
Oracle sqlldr TRAILING NULLCOLS required, but why?

I have an abstruse sqlldr problem that's bothering me. My control file looks something like this: load data infile 'txgen.…

oracle sql-loader
Disable and later enable all table indexes in Oracle

How would I disable and later enable all indexes in a given schema/database in Oracle? Note: This is to …

sql oracle sql-loader
How to populate a timestamp field with current timestamp using Oracle Sql Loader

I'm reading a pipe delimited file with SQL Loader and want to populate a LAST_UPDATED field in the table …

oracle sql-loader
Setting the Date Format in the SQL*Loader Control File

I have csv file that has "17 September, 2009 11:06:06 AM" as COMPLETED_ON variable I am using sql loader to load data …

oracle sql-loader to-date
Oracle Sql Loader skip option for multiple infiles

When using SQL Loader control file as following: OPTIONS(**skip=1**,bindsize=1048576,rows=1024) LOAD DATA INFILE 'C:\Documents and Settings\FIRST.…

oracle sql-loader
Difference Between Insert and Append statement in SQL Loader?

Can any one tell me the Difference Between Insert and Append statement in SQL Loader?consider the below example : Here …

oracle sql-loader
Skipping data fields while loading delimited data using SQLLDR

Consider below scenario: Table T1 (f1, f2, f3); Data files: a|b|c|d w|x|y|z I want …

oracle11g plsqldeveloper sql-loader
Loading Unicode Characters with Oracle SQL Loader (sqlldr) results in question marks

I'm trying to load localized strings from a unicode (UTF8-encoded) csv using SQL Loader into an oracle database. I've …

oracle unicode csv sql-loader
how to tell sqlldr to trim trailing and leading whitespace

I'm using sqlldr to load data in which some of the fields have trailing and leading whitespaces. Is there a …

removing-whitespace sql-loader