Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

What Are the Restrictions on External Table Columns?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

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.

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Load Data through External Tables?What Is a Directory Object?