Answers to Chapter 17
Reviewing It |
1: | What is the purpose of SQL*Loader? |
A1: | SQL*loader can load data from specifically formatted files (files with data fields in fixed locations), files where the fields have some kind of field separator such as a ':', data that is in its own definition file, or it can even load data via the Unix pipe command |
2: | Why would someone use External Tables instead of SQL*Loader? |
A2: | External tables gives the user the ability to run full SQL against the data, performing data conversions with DECODE, concatenations, and so on |
3: | Why would you want SQL*Loader to skip records? |
A3: | Perhaps there is some header information in the ... |
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.