notepad:mulling

차이

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

차이 보기로 링크

--- notepad:mulling [2010/10/04 17:34]
mulling
+++ notepad:mulling [2010/10/04 20:14]
mulling
@@ 줄 4: / 줄 4: @@
 - **중요한내용은 이렇게?**
-<code :sql>
+- <del>
 a2dev01:db2instl:/db2/db2instl>db2expln -d amedb01 -f 1 -t -g -z ';'
@@ 줄 21: / 줄 21: @@
 select *
-from DB2INSTL.DW_XXXXXX
+from DB2INSTL.DW_MACHINETIME_LTPS
 where ENDTIME >=TO_DATE('2010-06-01 00:00:00', 'YYYY-MM-DD
         HH24:MI:SS')and ENDTIME < TO_DATE('2010-07-01 00:00:00',
@@ 줄 42: / 줄 42: @@
            "MACHINENAME" , A0."MACHINETYPE" , A0."STARTTIME" , A0.
            "ITEMNAME" , A0."TIME"
-   FROM "ORADWADM" ."DW_XXXXXX" A0
+   FROM "ORADWADM" ."DW_MACHINETIME_LTPS" A0
    WHERE (TO_TIMESTAMP(:H0 )<=A0."ENDTIME" )AND (A0."ENDTIME" <
            TO_TIMESTAMP(:H1 ))Nicknames Referenced:
-: DB2INSTL.DW_XXXXXX   ID = 65533,32775
+: DB2INSTL.DW_MACHINETIME_LTPS  ID = 65533,32775
-    Base = ORADWADM.DW_XXXXXX #Input Columns = 2 #Output Columns = 10
+    Base = ORADWADM.DW_MACHINETIME_LTPS#Input Columns = 2 #Output Columns = 10
 End of section
@@ 줄 73: / 줄 73: @@
                 <65533,32775>
-</code>
+</del>

notepad/mulling.txt · 마지막으로 수정됨: 2010/10/06 14:39 저자 mulling