Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
How to make best use of the program.
|Section 1: SQL Loader Introduction|
What is SQL Loader?Preview
SQL Loader Components
Example 2 - Loading from File
Loading Options - Insert, Append, Replace and Truncate
Let's check the bad file...
Loading data from multiple files...
|Section 2: Modifying the data before Loading...|
Example 3 - FILLER keyword
Example 4 - CONSTANT keyword
Example 5 - Using SQL FunctionsPreview
Example 6 - Sequence values
|Section 3: Other Data Formats|
Example 7 - Multiple terminators in a single file
Example 8 - Data format with Fixed record length
Example 9 - Data format with Variable record lengthPreview
Example 10 - Stream of bytes
Example 11 - Fixed length Feilds
Example 12 - Formatted report
Example 12 - Trigger to populate the NULL values
Example 13 : Data format with multiple lines
Example 14 : Data format with multiple lines
|Section 4: Selectively loading the data...|
Example 15 - Selectively loading the data using Filters
Example 16 - Selectively loading the data using Filters
Example 17 - Loading into Multiple tables
Example 18 - Loading into Multiple tables and Filters
|Section 5: Loading into Complex Objects...|
Example 19 - Loading Objects
Example 20 - Loading Collections (VARRAY)
Example 21 - Loading Large objects (LOB's)
Loading a EBCDIC file
|Section 6: Direct Path Loads|
Conventional vs Direct path Loads
Example 22 - Direct path Loads
Restrictions when using Direct path Loads...
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.