2009 02 15 Externel SQL 연습..
sqlplus /as sysdba 1. c:\flat_files 폴더 생성. ex) > mkdir c:\flat_files > copy con c:\flat_files\ulcase1.ctl LOAD DATA INFILE * INTO TABLE DEPT FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (DEPTNO, DNAME, LOC) BEGINDATA 12,RESEARCH,"SARATOGA" 10,"ACCOUNTING",CLEVELAND 11,"ART",SALEM 13,FINANCE,"BOSTON" 21,"SALES",PHILA. 22,"SALES",ROCHESTER 42,"INT'L","SAN FRAN" (ctrl-z)