![\"\"](\"http:\/\/van-maanen.com\/wp-content\/uploads\/2020\/01\/Capture-17-1-12-1-1.png\")
<\/figure>\n\n\n\nThe generated script then looks like:<\/p>\n\n\n\n
–CREATE OR REPLACE DIRECTORY EXTERNORA AS ‘C:\\Users\\tomva\\externora’;
\n–GRANT READ ON DIRECTORY EXTERNORA TO USER;
\n–GRANT WRITE ON DIRECTORY EXTERNORA TO USER;
\n–drop table PRUT;
\nCREATE TABLE PRUT
\n( EMPLOYEE_ID NUMBER(38),
\n FIRST_NAME VARCHAR2(128),
\n LAST_NAME VARCHAR2(128),
\n EMAIL VARCHAR2(128),
\n PHONE_NUMBER VARCHAR2(128),
\n HIRE_DATE NUMBER(38),
\n JOB_ID VARCHAR2(128),
\n SALARY NUMBER(38),
\n COMMISSION_PCT NUMBER(38, 2),
\n MANAGER_ID NUMBER(38),
\n DEPARTMENT_ID NUMBER(38))
\nORGANIZATION EXTERNAL
\n ( TYPE ORACLE_LOADER
\n DEFAULT DIRECTORY EXTERNORA
\n ACCESS PARAMETERS
\n (records delimited BY ‘\\r\\n’
\n NOBADFILE
\n NODISCARDFILE
\n NOLOGFILE
\n skip 1
\n fields terminated BY ‘|’
\n OPTIONALLY ENCLOSED BY ‘”‘ AND ‘”‘
\n lrtrim
\n missing field VALUES are NULL
\n ( EMPLOYEE_ID CHAR(4000),
\n FIRST_NAME CHAR(4000),
\n LAST_NAME CHAR(4000),
\n EMAIL CHAR(4000),
\n PHONE_NUMBER CHAR(4000),
\n HIRE_DATE CHAR(4000),
\n JOB_ID CHAR(4000),
\n SALARY CHAR(4000),
\n COMMISSION_PCT CHAR(4000),
\n MANAGER_ID CHAR(4000),
\n DEPARTMENT_ID CHAR(4000)
\n )
\n )
\n LOCATION (‘export.csv’)
\n )
\n REJECT LIMIT UNLIMITED;<\/p>\n","protected":false},"excerpt":{"rendered":"
An external table is a flat file outside the Oracle database. If properly described in Oracle, it can be read as an Oracle table. The syntax consists of 3 elements: a create table part an ORGANIZATION EXTERNAL part that indicates that we are discussing an external table a set of attributes that discusses how the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3231","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3231"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3231\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3231"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"http:\/\/van-maanen.com\/wp-content\/uploads\/2020\/01\/Capture-17-2-1-1.png\")
<\/figure>\n\n\n\n