Which mandatory clause has to be added to the following statement to successfully create an external table called EMPDET?
CREATE TABLE empdet
(empno CHAR(2), ename CHAR(5), deptno NUMBER(4))
ORGANIZATION EXTERNAL
(LOCATION (’emp.dat’));
A.
TYPE
B.
REJECT LIMIT
C.
DEFAULT DIRECTORY
D.
ACCESS PARAMETERS
DEFAULT DIRECTORY is needed to specify the external source table’s location.
Very few sites that take place to become in depth beneath, from our point of view are undoubtedly effectively worth checking out.
Correct answer is C