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.

Equivalent of SQL loader in MySQL

I have found SQL loader in Oracle is very helpful, fast and efficient. What is the MySQL equivalent of SQL …

mysql sql sql-loader
Oracle SQL*loader running in direct mode is much slower than conventional path load

In the past few days I've playing around with Oracle's SQL*Loader in attempt to bulk load data into Oracle. …

performance oracle sql-loader
Load data from multiple data files into multiple tables using single ctl file

I have 3 data files and 3 staging tables. Is there any way to enter the data from the data files to …

sql-loader ctl
Issues with select statement in sql loader

I am not sure if this is possible or not, but here is my problem with select expression in a …

sql oracle sql-loader
Problem with Oracle Sql Loader control file

I'm trying to load some data using sql loader. Here is the top of my control/data file: LOAD DATA …

oracle sql-loader ora-01722
User Interface for creating Oracle SQL Loader control file

Is there a good user interface for authoring Oracle SQL Loader control files? PL/SQL Developer includes a "Text Importer" …

oracle ide sql-loader
Loading large amounts of data to an Oracle SQL Database

I was wondering if anyone had any experience with what I am about to embark on. I have several csv …

sql oracle insert bulkinsert sql-loader
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 …

sql-server sql-loader ctl controlfile