56. 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
Answer: C
Mandatory:强制 clause:条款
To create an external table, we’ll need to identify the location in the
operating system where the external file containing the table will reside.
01 CREATE TABLE INVOICES_EXTERNAL
02 ( INVOICE_ID CHAR(3),
03 INVOICE_DATE CHAR(9),
04 ACCOUNT_NUMBER CHAR(13)
05 )
06 ORGANIZATION EXTERNAL
07 (TYPE ORACLE_LOADER
08 DEFAULT DIRECTORY INVOICE_FILES
09 ACCESS PARAMETERS
10 (RECORDS DELIMITED BY NEWLINE
11 SKIP 2
12 FIELDS (INVOICE_ID CHAR(3),
13 INVOICE_DATE CHAR(9),
14 ACCOUNT_NUMBER CHAR(13))
15 )
16 LOCATION ('INVOICE_DATA.TXT')
17 );
57.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718840/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
