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, 1524🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...