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, 492👍, 0💬

Popular Posts:

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

GO - Sending a State...

How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...

ROUND() - Rounding V...

How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...