적수네 동네 - 질문과 답변 [ 게시물 수정 ]

	>> Edit article


			이름
			제목
			패스워드

다음 문장은 오라클 export 유틸리티로 뽑아낸 테이블 생성문장입니다.
전체 테이블은 약 3000개가 좀 넘습니다.
 CREATE TABLE "MEDI"."ACC0111" ("SYS_DATE" DATE, "USER_ID"
VARCHAR2(8), "UPD_DATE" DATE, "TP_BOJO1" VARCHAR2(1) NOT NULL ENABLE,
"CD_BOJO1" VARCHAR2(50) NOT NULL ENABLE, "NM_BOJO1" VARCHAR2(50),
"RMRK" VARCHAR2(50), "CHR_01" VARCHAR2(30), "CHR_02" VARCHAR2(30),
"CHR_03" VARCHAR2(30), "CHR_04" VARCHAR2(30), "CHR_05" VARCHAR2(30),
"CHR_06" VARCHAR2(30), "CHR_07" VARCHAR2(30), "NUM_01" NUMBER,
"NUM_02" NUMBER, "NUM_03" NUMBER, "NUM_04" NUMBER, "NUM_05" NUMBER,
"NUM_06" NUMBER, "NUM_07" NUMBER, "YMD_01" DATE, "YMD_02" DATE,
"YMD_03" DATE, "YMD_04" DATE, "YMD_05" DATE, "YMD_06" DATE, "YMD_07"
DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 40960 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TAB_8" ;
 CREATE TABLE "MEDI"."ACC0121" ("SYS_DATE" DATE, "USER_ID"
VARCHAR2(8), "UPD_DATE" DATE, "CD_SYSTEM" VARCHAR2(4) NOT NULL
ENABLE, "CD_INTERFACE" VARCHAR2(4) NOT NULL ENABLE, "TP_SUIP"
VARCHAR2(1) NOT NULL ENABLE, "CD_ACNT_DB" VARCHAR2(4), "CD_BOJO1_DB"
VARCHAR2(5), "CD_BOJO2_DB" VARCHAR2(5), "CD_ACNT_CR" VARCHAR2(5),
"CD_BOJO1_CR" VARCHAR2(20), "CD_BOJO2_CR" VARCHAR2(20), "RMRK"
VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 40960 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 249
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TAB_8" ;
 위 문장에서 &#039;;&#039;를 제외하고 아래처럼 모두 한줄로 만들고 싶습니다.
CREATE TABLE .... TABLESPACE "TAB_8";
CREATE TABLE .... TABLESPACE "TAB_8";
 :1, $ s/^M//g 를 해봐도 안되네요...
개행문자를 따로 찾을 수는 없을까요??
혹시 정규표현식을 가르쳐주실분???
 --
:wq!