external tables 썸네일형 리스트형 #25_140717_WSHOP_EXTERNAL TABLES # EXTERNAL TABLES emp1.txt 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_loaderdefault directory emp_dir2access parameters(records delimited by newlinefields terminated by ","(emp_name char,e.. 더보기 이전 1 다음