Collections:
What Is an External Table in Oracle
What Is an External Table in Oracle?
✍: FYIcenter.com
An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access drivers. Currently, Oracle supports two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP.
External tables can be used to load data from external files into database, or unload data from database to external files.
⇒ Load Data through External Tables in Oracle
⇐ Load Data with SQL*Loader in Oracle
2016-11-27, 1423👍, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...