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 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.