#25_140717_WSHOP_EXTERNAL TABLES

빅데이터과정/WORKSHOP 1

하히후후후 2014. 7. 17. 17:45

728x90

# EXTERNAL TABLES

n EXTERNAL TABLES(scott)

# ext1.txt 파일을 /oracle/home/ 위치에 저장해야 한다

SQL> create directory emp_dir2 as '/home/oracle/';

SQL> drop table ext_emp;

SQL> create table ext_emp

(emp_id number(3),

emp_name varchar2(10),

hiredate date)

organization external

(type oracle_loader

default directory emp_dir2

access parameters

(records delimited by newline

fields terminated by ","

(emp_name char,

emp_id char,

hiredate date "yyyy/mm/dd") )

location ('emp1.txt') );

SQL> select * from ext_emp;

EMP_ID EMP_NAME HIREDATE

---------- ---------- ---------

101 SMITH 15-MAR-01

102 JOHN 15-APR-02

101 SMITH 15-MAR-01

……………………………………………………………..

저작자표시 비영리 변경금지 (새창열림)