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

Popular Posts:

OUTPUT - Defining Ou...

How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...

GO - Sending a State...

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

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...

IF ... ELSE Statemen...

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

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...