SQL Loader - Learn in 22 Examples

Name: SQL Loader - Learn in 22 Examples
Rating: 4.5 (135 reviews)

Learn how to use SQL Loader Utility to load data from External files into Oracle database tables.

Created byAmarnath Reddy

Last updated 4/2016

English

What you'll learn

Effecitvely use the SQL Loader utility to load the data from external files into Oracle database

Course content

7 sections • 32 lectures • 1h 24m total length

How to make best use of the program.0:38

What is SQL Loader?4:20
Explore how SQL Loader loads data from external files into Oracle tables, across networks, with multi-file loading, character set options, and detailed error reports.
SQL Loader Components3:41
First Example5:14
Explore the SQL Loader course's first example, showing how a control file dictates loading data into a table, with fields terminated by a comma and a date format.
Example 2 - Loading from File2:47
Loading Options - Insert, Append, Replace and Truncate4:35
Let's check the bad file...3:21
Loading data from multiple files...0:26

Example 7 - Multiple terminators in a single file2:17
Example 8 - Data format with Fixed record length2:20
Process fixed-length data with a 66-byte record format and no line breaks. Define 66-byte fixed length in the control file and load seven records from the continuous stream.
Example 9 - Data format with Variable record length2:51
Example 10 - Stream of bytes1:53
Example 11 - Fixed length Feilds2:06
Example 12 - Formatted report3:45
Example 12 - Trigger to populate the NULL values0:55
Example 13 : Data format with multiple lines2:43
Example 14 : Data format with multiple lines2:06
Learn to load multi-line records with sql loader by using concatenate to group every two lines, and map columns by start positions in the control file.

Requirements

SQL Knowledge is a must!!!

Description

SQL Loader is an Oracle Utility that's been around almost as long as the Oracle database itself. It is an efficient and flexible tool that you can use to load large amounts of data into an Oracle database.

In simple terms, SQL Loader reads the data from flat files and inserts the data into one or more database tables.

If you would like to learn about SQL Loader, you have landed in the right course!!! This course explains the concepts using 21+ Examples, what else can you expect?

Students will be learning the below skills:

Understand the functionality of SQL Loader
Load data from Fixed Width files, Delimited Data and many other data format types.
Selectively loading the data
Transforming the data during Load
Direct Path Loads
Loading Large objects
Loading Objects and Collections
Performance tips...

Who this course is for:

This course is meant for students who are planing to invest their career in SQL.

SQL Loader - Learn in 22 Examples

What you'll learn

Explore related topics

Course content

How to make best use of the program.1 lecture • 1min

SQL Loader Introduction7 lectures • 24min

Modifying the data before Loading...4 lectures • 12min

Other Data Formats9 lectures • 21min

Selectively loading the data...4 lectures • 10min

Loading into Complex Objects...4 lectures • 12min

Direct Path Loads3 lectures • 5min

Requirements

Description

Who this course is for: