Oracle SQL Loader - Control File Example - Tutorial -2

Pubblicato il: 31 luglio 2018
sul canale di: Kishan Mashru

17,644

204

This is the second video on Oracle SQL*Loader tutorials. Here we talk about the heart of the Oracle SQL Loader i.e Control File with an example, the structure of the control file and how to write one. We discuss all this by looking at an SQL Loader example.

We talk about the format of the data files and the advantages of using delimited data format against fixed width data format.

What you will learn in this video
1. What is Control File in SQL Loader?
2. You will get an understanding on the various clauses of Control File like LOAD DATA, INFILE, INTO TABLE, FIELDS TERMINATED BY etc.
3. Example of Control File.

If you would like to check the other tutorial videos on SQL Loader:

First video visit    • Oracle SQL Loader - Introduction - Tu...
Third video visit    • Oracle SQL Loader - How to load data ...

If you would like to understand the advantages of delete over a truncate then visit the following video :
Delete VS Truncate:    • Difference between Delete and Truncat...

Check out our blog at: http://oracleplsqlblog.com/

#KishanMashru #Oracle #SqlLoader #ControlFile #Example #SqlLoaderConcept #SqlLoaderIntroduction #SQLandPLSQL #OracleSqlLoader
#ETL #database

In questa pagina del sito puoi guardare il video online Oracle SQL Loader - Control File Example - Tutorial -2 della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Kishan Mashru 31 luglio 2018, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 17,644 volte e gli è piaciuto 204 spettatori. Buona visione!

262