notepad:mulling

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- notepad:mulling [2010/10/05 19:35]
mulling 옛 버전 복구
+++ notepad:mulling [2010/10/06 14:39] (현재)
mulling
@@ 줄 1: / 줄 1: @@
-- <del>삭제예정은 이렇게 표시</del>
+^ 1장      ^ 2장        ^ 3장          ^
+| 1행1열    | 1행2열     | 1행3열        |
+| 2행1열    | 교차 (파이프 두개)        ||
+| 3행1열    | 3행2열     | 3행3열        |
+| 4행1열    | 3행2열     | 4행3열        |
-- SQL은 이렇게~<code :sql> select dummy from dual</code>
-- **중요한내용은 이렇게?**
-<code :sql>
----------------------------------------------------------------------------------------------------------------------------------------------------
-.to_date 함수 안씌우고 date 비교 ex) 컬럼 >= '2010-07-01'
-select *
-from DB2INSTL.DW_XXXXXX
-where ENDTIME >='2010-07-01' and ENDTIME < '2010-08-01'
-SELECT *
-FROM "ORACLE" ."DW_XXXXXX" A0
-WHERE (TO_TIMESTAMP('20100701 000000000000', 'YYYYMMDD HH24MISSFF6') <=A0."ENDTIME" )
-AND (A0."ENDTIME" < TO_TIMESTAMP('20100801 000000000000', 'YYYYMMDD HH24MISSFF6'))
-.DDL
-<< Oracle >>
-CREATE TABLE ORADWADM.DW_XXXXXX
-(
-  PRTNAME           		VARCHAR2(30 BYTE),
-  LTNAME               	VARCHAR2(30 BYTE),
-  PRTIONTYPE        		VARCHAR2(30 BYTE),
-  PROCESSOPNAME  				VARCHAR2(30 BYTE),
-  MNAME           			VARCHAR2(30 BYTE),
-  MTYPE           			VARCHAR2(30 BYTE),
-  STARTTIME             DATE,
-  ENDTIME               DATE,
-  ITEMNAME              VARCHAR2(30 BYTE),
-  TIME                  NUMBER
-)
-TABLESPACE TS_DAT
-PARTITION BY RANGE (ENDTIME)
-(
-  PARTITION PT_XXXXXX_0801 VALUES LESS THAN (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
-  PARTITION PT_XXXXXX_0802 VALUES LESS THAN (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
-  ...
-  PARTITION PT_XXXXXX_1101 VALUES LESS THAN (TO_DATE(' 2011-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
-)
-<< DB2 >>
-CREATE TABLE "EDBUSER "."DW_XXXXXX"
-(
-  "PRTNAME" 						VARCHAR(30) NOT NULL ,
-  "LTNAME" 							VARCHAR(30) ,
-  "PRTIONTYPE" 					VARCHAR(30) ,
-  "PROCESSOPNAME" 			VARCHAR(30) ,
-  "MNAME" 							VARCHAR(30) ,
-  "MTYPE" 							VARCHAR(30) ,
-  "STARTTIME" 					TIMESTAMP NOT NULL ,
-  "ENDTIME" 						TIMESTAMP NOT NULL ,
-  "ITEMNAME" 						VARCHAR(30) NOT NULL ,
-  "TIME" 								DOUBLE
-)
-COMPRESS YES
-DISTRIBUTE BY HASH("PRODUCTNAME","STARTTIME","ITEMNAME")
-PARTITION BY RANGE("ENDTIME")
-(
-  PART "PT_XXXXXX_0801" STARTING(MINVALUE) ENDING('2008-02-01-00.00.00.000000') EXCLUSIVE IN "DW_MD_TS" INDEX IN "DW_MI_TS",
-  PART "PT_XXXXXX_0802" ENDING('2008-03-01-00.00.00.000000') EXCLUSIVE IN "DW_MD_TS" INDEX IN "DW_MI_TS",
-  ...
-  PART "PT_XXXXXX_1101" ENDING('2011-02-01-00.00.00.000000') EXCLUSIVE IN "DW_MD_TS" INDEX IN "DW_MI_TS"
-);
-.오라클 호환모드
-=> 현재 설정되어 있지 않음!!
----------------------------------------------------------------------------------------------------------------------------------------------------
-</code>

notepad/mulling.1286274908.txt.gz · 마지막으로 수정됨: 2010/10/05 19:35 저자 mulling