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.

SQL Loader with utf8

I am getting following error while loading Japanese data using SQL*Loader. My Database is UTF8 (NLS parameters) and my …

oracle utf-8 sql-loader
How do I set sqlldr log file within control file

I have a sqlldr (Oracle SQL Loader) control file (say myControlFile.ctl) and when run it all works OK. However, …

oracle sql-loader
SQL*Loader: Dealing with delimiter characters in data

I am loading some data to Oracle via SQLLDR. The source file is "pipe delimited". FIELDS TERMINATED BY '|' …

oracle sql-loader oracle11gr2
Can variables be passed to a SQL*Loader control file?

Suppose you have a table: CREATE TABLE Customer ( batch_id NUMBER, customer_name VARCHAR2(20), customer_address VARCHAR2(100) ) And suppose you …

oracle sql-loader
Date format for SQL*Loader

I am trying to import a file of records into a table and am getting Rejected - Error on table …

sql oracle sql-loader
loading csv file data into oracle database

I am trying to load a csv file in oracle database using sql loader through java program. I have successfully …

java sql-loader
import csv file into table using SQL Loader [but large no. of Columns]

I want to import data in the form of csv file into a table.[using Oracle SQL developer].I have …

sql oracle sql-loader
SQL Loader ctl file - how to skip columns

Let's say in my database 4 columns: Column1, Column2, Column3, Column4 My data file is CSV file (comma delimited, length of …

sql oracle sql-loader ctl
SQL*Loader - How can i ignore certain rows with a specific charactre

If i have a CSV file that is in the following format "fd!","sdf","dsfds","dsfd" "fd!","asdf","dsfds","dsfd" "…

oracle sql-loader
concatenate multiple fields in sqlldr

I am working on sqlldr(sql loader) in oracle 11g. I am trying to concatenate 3 fields into a single field. …

bash shell oracle11g sql-loader