Oracle Data Load - What Is SQL*Loader

What Is SQL*Loader

Q

What Is SQL*Loader? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

SQL*Loader is a database tool that allows to load data from external files into database tables. SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting features as:

Can load data from multiple data files into multiple tables in one load session.
Can specify character set of the data.
Can generate sophisticated error reports.
Can load data directly to Oracle datafiles, bypassing normal record inserting process.

2007-04-30, 5099👍, 0💬

How To Load Data with SQL*Loader
How To Load Data with SQL*Loader? - Oracle DBA FAQ - Loading and Exporting Data Let's say you have a table defined as: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL)... 2007-04-30, 4899👍, 0💬

What Is a SQL*Loader Control File
What Is a SQL*Loader Control File? - Oracle DBA FAQ - Loading and Exporting Data A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify: Where is the input data file. The format of the input date file. The target table where the data... 2007-04-30, 4661👍, 0💬

What Is the Quickest Way to Export a Table to a Flat File
What Is the Quickest Way to Export a Table to a Flat File? - Oracle DBA FAQ - Loading and Exporting Data The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following ... 2007-04-30, 4463👍, 0💬

How To Export Data with a Field Delimiter
How To Export Data with a Field Delimiter? - Oracle DBA FAQ - Loading and Exporting Data The previous exercise allows you to export data with fixed field lengths. If you want export data with variable field lengths and field delimiters, you can concatenate your fields with an expression in the SELEC... 2007-04-30, 4372👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.