외부 DATA 불러오기

== 외부파일 불러오기
--F52 53

CREATE  TABLE  TBL_STUDENT01
(NO NUMBER,
NAME VARCHAR2(10)
,HAKGUA VARCHAR2(10)
);

SELECT *
FROM TBL_STUDENT01;
--F54

--F55 56 57 58 59

SELECT *
FROM TBL_STUDENT01;
--F60

--F61~67

SELECT *
FROM TBL_STUDENT01;
--F70

--F68~69

전부 삭제하고 다시 넣을 때는
REPLACE를 사용
--F78 79

NULL 값이 있을때는 TRAILING NULLCOLS 를 CTL의 COLUMN 지정앞에 넣음!
--F80 81

CREATE TABLE TBL_MEMBER(
NO NUMBER,
NAME VARCHAR2(10),
JUBUN VARCHAR2(13),
GENDER VARCHAR2(2),
JIK VARCHAR(10)
)

SELECT * FROM TBL_MEMBER;

-F 71~74

 

CREATE TABLE TBL_MEMBER2(
NO NUMBER,
NAME VARCHAR2(10),
JUBUN VARCHAR2(13),
GENDER VARCHAR2(2),
JIK VARCHAR2(10),
AGE NUMBER
);
SELECT * FROM TBL_MEMBER2;
--F82

SELECT CASE WHEN SUBSTR('0012313234567',1,1) = '0' AND SUBSTR('0012313234567',7,1) 
IN ('3','4') THEN TO_CHAR(SYSDATE,'YY') - (SUBSTR('0012313234567',1,2)) +1
 ELSE TO_CHAR(SYSDATE,'YY') - (SUBSTR('0012313234567',1,2)) +101 END  "TEST"
FROM DUAL;

SELECT CASE WHEN SUBSTR('7812312234567',1,1) = '0' AND SUBSTR('7812312234567',7,1) 
IN ('3','4') THEN TO_CHAR(SYSDATE,'YY') - (SUBSTR('7812312234567',1,2)) +1
 ELSE TO_CHAR(SYSDATE,'YY') - (SUBSTR('7812312234567',1,2)) +101 END  "TEST"
FROM DUAL;
--F83

--F84-86

SELECT * FROM TBL_MEMBER2;

CREATE TABLE TBL_ZIP
(ZIPCODE VARCHAR2(10),
 SIDO VARCHAR2 (200),
 GUGUN VARCHAR2(200),
 DONG VARCHAR2(200),
 RI VARCHAR2(200),
 BLDG VARCHAR2(200),
 BUNJI VARCHAR2(200),
 SEQ NUMBER);

SELECT * FROM TBL_ZIP;

--F2

SELECT * FROM TBL_ZIP;
COMMIT;
--F3~8