Oracle - Restrictions on External Table Columns in Oracle

Restrictions on External Table Columns in Oracle

Q

What Are the Restrictions on External Table Columns in Oracle?

✍: FYIcenter.com

A

When creating external table columns, you need to watch out some restrictions:

"PRIMARY KEY" is not allowed.
"NOT NULL" is not allowed.
"DEFAULT value" is not allowed.

⇒Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-11-27, 532👍, 0💬

Popular Posts:

"sys.tables" - Getti...

How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

Error: Subquery Retu...

What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...