{"id":427,"date":"2014-12-04T15:20:50","date_gmt":"2014-12-05T00:20:50","guid":{"rendered":"http:\/\/blog.box.kr\/?p=427"},"modified":"2014-12-04T15:20:50","modified_gmt":"2014-12-05T00:20:50","slug":"db-db%eb%b3%84-%ea%b0%80%ec%83%81-%ed%85%8c%ec%9d%b4%eb%b8%94","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=427","title":{"rendered":"[DB] DB\ubcc4 \uac00\uc0c1 \ud14c\uc774\ube14"},"content":{"rendered":"<p>Oracle ] select aaaa from dual<\/p>\n<p>DB2] select aaaa from\u00a0sysibm.sysdummy1<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle ] select aaaa from dual DB2] select aaaa from\u00a0sysibm.sysdummy1 &nbsp;<\/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,5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-6T","jetpack-related-posts":[{"id":275,"url":"https:\/\/blog.box.kr\/?p=275","url_meta":{"origin":427,"position":0},"title":"DB\ubcc4 \ud568\uc218 \ube44\uad50","date":"2014-08-05","format":false,"excerpt":"isnull => DB2\u00a0COALESCE strcat = > || \ub85c \ubb36\uae30 \u00a0 \u00a0 MySQL: -- Convert the current date to YYYYMM format \u00a0\u00a0SELECT DATE_FORMAT(NOW(), '%Y%m'); DB2: -- Convert the current date to YYYYMM format \u00a0\u00a0SELECT VARCHAR_FORMAT(CURRENT_DATE, 'YYYYMM') FROM sysibm.sysdummy1;","rel":"","context":"In &quot;\uc77c\uc0c1&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":291,"url":"https:\/\/blog.box.kr\/?p=291","url_meta":{"origin":427,"position":1},"title":"Many to Many Join \uad00\ub828..","date":"2014-08-07","format":false,"excerpt":"\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. \u00a0 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.\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":425,"url":"https:\/\/blog.box.kr\/?p=425","url_meta":{"origin":427,"position":2},"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 &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":741,"url":"https:\/\/blog.box.kr\/?p=741","url_meta":{"origin":427,"position":3},"title":"[DB2] how to use Sequence table","date":"2015-05-07","format":false,"excerpt":"1. describe sequence table describe table syscat.sequences; 2.\u00a0 select sequence information SELECT * FROM syscat.sequences; 3. create sequence CREATE SEQUENCE seq_tab START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 24; -> start 1, increment\u00a01 by 1 \u00a0to\u00a0\u00a0no limit CREATE SEQUENCE seq_tab START WITH 1 INCREMENT BY 1 maxvalue 10000\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":619,"url":"https:\/\/blog.box.kr\/?p=619","url_meta":{"origin":427,"position":4},"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 &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":345,"url":"https:\/\/blog.box.kr\/?p=345","url_meta":{"origin":427,"position":5},"title":"Alter Table [ \uceec\ub7fc \uc0ac\uc774\uc988, \ub370\uc774\ud130 \ud06c\uae30 \uc870\uc815 ]","date":"2014-08-17","format":false,"excerpt":"[DB2] \ucef4\ub7fc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \ub610\ub294 \uc0ac\uc774\uc988 \uc870\uc815 ALTERTABLE temp \u00a0 \u00a0\u00a0ALTERCOLUMN col1 SET DATA TYPE VARCHAR(60); [ORACLE] alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 column_name\u00a0 datatype; \uc774\ub7f0\uc2dd\uc73c\ub85c\ub3c4 \ub41c\ub2e4.. alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 (\u00a0\u00a0 column1_name\u00a0 column1_datatype,\u00a0\u00a0 column2_name\u00a0 column2_datatype,\u00a0\u00a0 column3_name\u00a0 column3_datatype,\u00a0\u00a0 column4_name\u00a0 column4_datatype\u00a0\u00a0 ); [MYSQL] alter table people modify name VARCHAR(35) ;","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/427"}],"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=427"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/427\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}