When creating an external table, which allows you to access data in a flat file as though it is a table inside the database, certain clauses are required:
A. the ACCESS PARAMETERS clause: This clause specifies the parameters required by the access driver to read the data files.
D. the LOCATION clause: This clause specifies the location of the data files that make up the external table.
References:
Oracle Database SQL Language Reference 12c, particularly the sections detailing the creation and management of external tables.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit