\ud558\ub2e4\ubcf4\uba74. A\ud14c\uc774\ube14\uc758 1\uac1c \ub2f9 \u00a0B\ud14c\uc774\ube14\uc758 \uc804\ubd80\ub97c \u00a0Join \ud560 \ud544\uc694\uac00 \uc788\ub2e4.<\/p>\n
( ex 1\uc6d4 \ubd80\ud130 12\uc6d4 \uae4c\uc9c0\uc758 \uc6d4 \ud14c\uc774\ube14\uc5d0 \ub9e4\ucd9c \uc815\ubcf4\ub97c Join \ud574\uc57c \ud560 \uacbd\uc6b0 )<\/p>\n
\uc774\ub54c\ub294 Cross Join \uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n
<\/p>\n
Join \uba85\uba85 \uc5c6\uc774 \uadf8\ub0e5 Old Style\ub85c , \ub85c \ud14c\uc774\ube14\uc744 \uc5ee\uc73c\uba74 \uc55e \ud14c\uc774\ube14 \uae30\uc900\uc73c\ub85c \ub4a4 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ubb36\uc5b4 \uc900\ub2e4.<\/p>\n
<\/p>\n
select mon,locode, replace(substr(mon,1,1),’0′,”)||substr(mon,2,1) as months
\nfrom (
\nSELECT * FROM
\n(
\nSELECT ’01’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’02’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’03’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’04’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’05’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’06’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’07’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’08’ AS mon FROM sysibm.sysdummy1 union all
\nSELECT ’09’ AS mon FROM sysibm.sysdummy1 union ALL
\nSELECT ’10’ AS mon FROM sysibm.sysdummy1 union ALL
\nSELECT ’11’ AS mon FROM sysibm.sysdummy1 union ALL
\nSELECT ’12’ AS mon FROM sysibm.sysdummy1
\n) ia,
\n( SELECT lo_code AS locode FROM POS_ASP_USER_COMPNO WHERE ID_CODE = ‘dadafc01’ ) ib
\nORDER BY ib.locode, ia.mon
\n) a<\/p>\n
<\/p>\n
\uc774\ub807\uac8c \ucc98\ub9ac..<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\ud558\ub2e4\ubcf4\uba74. A\ud14c\uc774\ube14\uc758 1\uac1c \ub2f9 \u00a0B\ud14c\uc774\ube14\uc758 \uc804\ubd80\ub97c \u00a0Join \ud560 \ud544\uc694\uac00 \uc788\ub2e4. ( ex 1\uc6d4 \ubd80\ud130 12\uc6d4 \uae4c\uc9c0\uc758 \uc6d4 \ud14c\uc774\ube14\uc5d0 \ub9e4\ucd9c \uc815\ubcf4\ub97c Join \ud574\uc57c \ud560 \uacbd\uc6b0 ) \uc774\ub54c\ub294 Cross Join \uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. Join \uba85\uba85 \uc5c6\uc774 \uadf8\ub0e5 Old Style\ub85c , \ub85c \ud14c\uc774\ube14\uc744 \uc5ee\uc73c\uba74 \uc55e \ud14c\uc774\ube14 \uae30\uc900\uc73c\ub85c \ub4a4 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ubb36\uc5b4 \uc900\ub2e4. select mon,locode, replace(substr(mon,1,1),’0′,”)||substr(mon,2,1) as months from ( SELECT * FROM ( SELECT ’01’ AS mon FROM sysibm.sysdummy1 union all SELECT ’02’ AS mon FROM sysibm.sysdummy1 union all SELECT ’03’ AS mon FROM sysibm.sysdummy1 union all SELECT ’04’ AS mon FROM sysibm.sysdummy1 union all SELECT ’05’ AS mon FROM sysibm.sysdummy1 union all SELECT ’06’ AS mon FROM sysibm.sysdummy1 union all SELECT ’07’ AS mon FROM sysibm.sysdummy1 union all SELECT ’08’ AS mon FROM sysibm.sysdummy1 union all SELECT ’09’ AS mon FROM sysibm.sysdummy1 union ALL SELECT ’10’ AS mon FROM sysibm.sysdummy1 union ALL SELECT ’11’ AS mon FROM sysibm.sysdummy1 union ALL SELECT ’12’ AS mon FROM sysibm.sysdummy1 ) ia, ( SELECT lo_code AS locode FROM POS_ASP_USER_COMPNO WHERE ID_CODE = ‘dadafc01’ ) ib ORDER BY ib.locode, ia.mon ) a \uc774\ub807\uac8c \ucc98\ub9ac.. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[12],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-4H","jetpack-related-posts":[{"id":1284,"url":"https:\/\/blog.box.kr\/?p=1284","url_meta":{"origin":291,"position":0},"title":"MySql \uad00\ub9ac","date":"2021-12-30","format":false,"excerpt":"Table\uc5d0 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 Indexes \uc758 \uc6a9\ub7c9 \ud655\uc778 select database_name, table_name, index_name, round((stat_value*@@innodb_page_size)\/1024\/1024, 2) SizeMB, round(((100\/(SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = iis.table_name and t.TABLE_SCHEMA = iis.database_name))*(stat_value*@@innodb_page_size)), 2) `Percentage` from mysql.innodb_index_stats iis where stat_name='size' and table_name = 'TargetTable' and database_name = 'targetDB' show table status from database_name; -- databases\uc5d0 \uc788\ub294\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":425,"url":"https:\/\/blog.box.kr\/?p=425","url_meta":{"origin":291,"position":1},"title":"[DB] SQL Syntax ( With \ubb38 )","date":"2014-12-03","format":false,"excerpt":"[Oracle] WITH \uad6c\ubb38 \uc608\uc81c \u00a0 [WITH \uad6c\ubb38] - WITH\uad6c\ubb38\ub0b4\uc758 \ucffc\ub9ac\uc758 \uacb0\uacfc(SUB\ucffc\ub9ac)\uac00\u00a0\uc5ec\ub7ec\ubc88 \uc0ac\uc6a9\ub420\ub54c(\ud638\ucd9c\ub420\ub54c) \uc720\uc6a9\ud558\ub2e4. - \uc11c\ube0c\ucffc\ub9ac \ube14\ub7ed\uc5d0 \uc774\ub984\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90c. - \uc624\ub77c\ud074 \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \ucffc\ub9ac\ub97c \uc778\ub77c\uc778\ubdf0\ub098 \uc784\uc2dc \ud14c\uc774\ube14\ub85c \uc5ec\uae34\ub2e4. - Oracle 9 \uc774\uc0c1 \uc9c0\uc6d0 \u00a0 \u00a0 [WITH \uad6c\ubb38 \uc0ac\uc6a9\ubc29\ubc95] WITH ALIAS\uba85 AS ( SUB\ucffc\ub9ac ) SELECT \uceec\ub7fc\uba85 FROM\u00a0ALIAS\uba85; \u00a0 WITH\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":619,"url":"https:\/\/blog.box.kr\/?p=619","url_meta":{"origin":291,"position":2},"title":"[\ud38c][IBM][CLI Driver] SQL0418N SQLSTATE=42610","date":"2015-03-13","format":false,"excerpt":"\uac1c\uad04 :\u00a0[IBM][CLI Driver] SQL0418N\u00a0SQLSTATE=42610 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\uba85\ub839\ubb38\uc5d0 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc6d0\uc778: \ub2e4\uc74c \uacbd\uc6b0\uc5d0\ub294 \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. SELECT \ubaa9\ub85d\uc5d0\uc11c \ub0a0\uc9dc \uc2dc\uac04 \uc0b0\uc220 \uc5f0\uc0b0\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc2a4\uce7c\ub77c \ud568\uc218\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c ORDER BY\uc808\uc5d0\uc11c \uc815\ub82c \ud0a4\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc900\ube44\ub41c \uba85\ub839\ubb38\uc774\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":427,"url":"https:\/\/blog.box.kr\/?p=427","url_meta":{"origin":291,"position":3},"title":"[DB] DB\ubcc4 \uac00\uc0c1 \ud14c\uc774\ube14","date":"2014-12-04","format":false,"excerpt":"Oracle ] select aaaa from dual DB2] select aaaa from\u00a0sysibm.sysdummy1 \u00a0","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":291,"position":4},"title":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8","date":"2015-05-18","format":false,"excerpt":"http:\/\/blog.hibrainapps.net\/130 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MySQL\uc744 DB\ub85c \uc0ac\uc6a9\ud558\uba74\uc11c \uc11c\ubc84\uc758 \ubd80\ud558 \ubd84\uc0b0\uc744 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\ub85c Replication \uc744 \uc0ac\uc6a9\ud55c\ub2e4. Replication \uc740 Master \ud558\ub098\uc5d0 n\uac1c\uc758 Slave\ub85c \uc9c0\uc815\uc774 \uac00\ub2a5\ud558\ub2e4. Slave\ub294 \ub2e4\uc2dc Master \uc5ed\ud560\uc744 \ud560\uc218 \uc788\uc73c\uba70 \uc5ed\uc2dc \ub610 \ub2e4\ub978 n\uac1c\uc758 Slave\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":590,"url":"https:\/\/blog.box.kr\/?p=590","url_meta":{"origin":291,"position":5},"title":"[\ud38c]Java \uc5d0\uc11c DataBase Replication Master\/Slave (write\/read) \ubd84\uae30 \ucc98\ub9ac\ud558\uae30 \ud504\ub85c\uadf8\ub798\ubc0d","date":"2015-01-30","format":false,"excerpt":"Cloud\ud658\uacbd\uc5d0\uc11c DB\ub97c \uc0ac\uc6a9\ud558\ub2e4\ubcf4\ub2c8 Disk I\/O\ub098 \ub108\ubb34 \ub290\ub824\uc11c \ub9ce\uc740 \uace0\ubbfc\uc744 \ud558\uac8c \ub410\ub2e4. \uc77c\ub2e8 \uc0dd\uac01\ub098\ub294\uac83\uc774 \ub9ce\uc774 \ub4e4 \ud558\ub294 Replication\uc744 \uc774\uc6a9\ud55c \ubd80\ud558\ubd84\uc0b0 ( Master\ub294 Insert\/Update\ub9cc, Slave\ub294 SELECT\ub9cc ) \uadf8\ub7f0\ub370 \ub9c9\uc0c1 \ud560\ub824\uba74 \uc774\uac83 \uc800\uac83 \uc190\uc774 \ub9ce\uc774 \uac04\ub2e4.. \uadf8\ub798\uc11c.. \uc0dd\uac01\ub9cc \ud558\uace0 \uc801\uc6a9\uc744 \uc548\ud588\uc5c8\ub294\ub370.. \u00a0 \uc6f9\uc11c\ud551\uc744 \ud558\ub2e4\uac00 \uc774\ub7f0 \uae00\uc744 \ubc1c\uacac.. \uc544!! \uc774\ub807\uac8c \uc88b\uc744 \uc218\uac00.. \u00a0 \uc5ed\uc2dc\u2026","rel":"","context":"In "JAVA"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/291"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=291"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}