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, 3145🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Get Help Information from the Server in MySQL? While you are at the "mysql>" prompt, y...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...