Oracle - What Is an External Table in Oracle

What Is an External Table in Oracle

Q

What Is an External Table in Oracle?

✍: FYIcenter.com

A

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.

⇒Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-11-27, 435👍, 0💬

Popular Posts:

Connecting SQL Serve...

How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

Formatting Time Zone...

How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...