SQL Loader Tutorial

Example 1: Loading Variable length Data

Example 1: demonstartes the following

• A simple control file identifying one table and three columns to be loaded.
• Including the data to be loaded in the control file itself, so there is no separate data file.

Oracle SQL* Loader Concepts

Introduction

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

Capabilities of SQL*Loader

•          Can load data from multiple data files during the same load session.

•          Can load data into multiple tables during the same load session.

•          Can selectively load data (Records can be loaded based on the records' values).

•          Can manipulate the data before loading it, using SQL functions.

•          Can generate unique sequential key values in specified columns .

Does sophisticated error reporting which greatly aids troubleshooting

Oracle SQL*Loader

General

Note: This page consists of a series of demonstrations of various SQL*Loader capabilities. It is by no means complete.

Oracle SQL Loader Utility

Abstract

The document is aimed at describing the procedure to be followed while working with SQL Loader Utility. Using the tool, we can load the external data coming in various formats like excel sheet, flat text file, comma Separated Variable (.csv) files and so on.