Generate external table definitions from SQL*Loader

Thursday Oct 5th 2006 by Staff

External tables in Oracle enable you to query text files with the full power of the SQL language. Here is a quick way to create them using scripts generated by SQL*Loader.


External tables, introduced in Oracle 9i, enable you to map a sequential text file to an Oracle table definition. Once the external table is defined, you can use the full power of the SQL SELECT statement—including parallel querying—to process it.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved