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.
2016-11-27, 848👍, 0💬
Popular Posts:
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...