{"id":425,"date":"2014-12-03T21:18:17","date_gmt":"2014-12-04T06:18:17","guid":{"rendered":"http:\/\/blog.box.kr\/?p=425"},"modified":"2014-12-03T21:18:17","modified_gmt":"2014-12-04T06:18:17","slug":"db-sql-syntax-with-%eb%ac%b8","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=425","title":{"rendered":"[DB] SQL Syntax ( With \ubb38 )"},"content":{"rendered":"

[Oracle] WITH \uad6c\ubb38 \uc608\uc81c<\/strong><\/p>\n

 <\/p>\n

[WITH \uad6c\ubb38]<\/p>\n

– 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.<\/p>\n

– \uc11c\ube0c\ucffc\ub9ac \ube14\ub7ed\uc5d0 \uc774\ub984\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90c.<\/p>\n

– \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.
\n– Oracle 9 \uc774\uc0c1 \uc9c0\uc6d0<\/p>\n

 <\/p>\n

 <\/p>\n

[WITH \uad6c\ubb38 \uc0ac\uc6a9\ubc29\ubc95]<\/p>\n

\n

WITH ALIAS\uba85 AS ( SUB\ucffc\ub9ac )<\/p>\n

SELECT \uceec\ub7fc\uba85 FROM\u00a0ALIAS\uba85;<\/p>\n<\/div>\n

 
\n<\/span><\/p>\n

WITH \uad6c\ubb38 \uc608\uc81c)<\/p>\n

\n

WITH AA AS<\/p>\n

(SELECT ROWNUM, ‘TEST1’, SYSDATE<\/p>\n

FROM DUAL<\/p>\n

UNION ALL<\/p>\n

SELECT ROWNUM, ‘TEST2’, SYSDATE<\/p>\n

FROM DUAL<\/p>\n

UNION ALL<\/p>\n

SELECT ROWNUM, ‘TEST3’, SYSDATE FROM DUAL)<\/p>\n

SELECT * FROM AA;<\/p>\n<\/div>\n

 <\/p>\n

\"\"<\/span><\/span><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

[WITH \uad6c\ubb38(2\uac1c SUB\ucffc\ub9ac) \uc0ac\uc6a9\ubc29\ubc95]<\/p>\n

\n

WITH ALIAS\uba85_1 AS ( SUB\ucffc\ub9ac ),<\/p>\n

ALIAS\uba85_2 AS ( SUB\ucffc\ub9ac )<\/span><\/p>\n

SELECT \uceec\ub7fc\uba85 FROM\u00a0ALIAS\uba85 where \uc870\uc778\uc870\uac74;<\/p>\n<\/div>\n

 <\/p>\n

WITH \uad6c\ubb38(2\uac1c SUB\ucffc\ub9ac) \uc608\uc81c)<\/p>\n

\n

WITH AA AS
\n(SELECT ROWNUM AS SEQ, ‘TEST1’ AS NAME, SYSDATE
\nFROM DUAL
\nUNION ALL
\nSELECT ROWNUM AS SEQ, ‘TEST2’ AS NAME, SYSDATE
\nFROM DUAL
\nUNION ALL
\nSELECT ROWNUM AS SEQ, ‘TEST3’ AS NAME, SYSDATE FROM DUAL),<\/p>\n

BB AS
\n(SELECT ROWNUM AS SEQ, ‘TEST1’ AS NAME, SYSDATE
\nFROM DUAL
\nUNION ALL
\nSELECT ROWNUM AS SEQ, ‘TEST2’ AS NAME, SYSDATE
\nFROM DUAL
\nUNION ALL
\nSELECT ROWNUM AS SEQ, ‘TEST3’ AS NAME, SYSDATE FROM DUAL)<\/p>\n

SELECT * FROM AA, BB WHERE AA.NAME=BB.NAME<\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n

\"\"<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

[Oracle] WITH \uad6c\ubb38 \uc608\uc81c   [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     [WITH \uad6c\ubb38 \uc0ac\uc6a9\ubc29\ubc95] WITH ALIAS\uba85 AS ( SUB\ucffc\ub9ac ) SELECT \uceec\ub7fc\uba85 FROM\u00a0ALIAS\uba85;   WITH \uad6c\ubb38 \uc608\uc81c) WITH AA AS (SELECT ROWNUM, ‘TEST1’, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM, ‘TEST2’, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM, ‘TEST3’, SYSDATE FROM DUAL) SELECT * FROM AA;         [WITH \uad6c\ubb38(2\uac1c SUB\ucffc\ub9ac) \uc0ac\uc6a9\ubc29\ubc95] WITH ALIAS\uba85_1 AS ( SUB\ucffc\ub9ac ), ALIAS\uba85_2 AS ( SUB\ucffc\ub9ac ) SELECT \uceec\ub7fc\uba85 FROM\u00a0ALIAS\uba85 where \uc870\uc778\uc870\uac74;   WITH \uad6c\ubb38(2\uac1c SUB\ucffc\ub9ac) \uc608\uc81c) WITH AA AS (SELECT ROWNUM AS SEQ, ‘TEST1’ AS NAME, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM AS SEQ, ‘TEST2’ AS NAME, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM AS SEQ, ‘TEST3’ AS NAME, SYSDATE FROM DUAL), BB AS (SELECT ROWNUM AS SEQ, ‘TEST1’ AS NAME, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM AS SEQ, ‘TEST2’ AS NAME, SYSDATE FROM DUAL UNION ALL SELECT ROWNUM AS SEQ, ‘TEST3’ AS NAME, SYSDATE FROM DUAL) SELECT * FROM AA, BB WHERE AA.NAME=BB.NAME    <\/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,7],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-6R","jetpack-related-posts":[{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":425,"position":0},"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":514,"url":"https:\/\/blog.box.kr\/?p=514","url_meta":{"origin":425,"position":1},"title":"word2Vec.. \uae30\uacc4\ud559\uc2b5\uc758 \ud604\uc2e4\ud654..","date":"2014-12-28","format":false,"excerpt":"\uc694\uc998 \uba38\uc2e0\ub7ec\ub2dd \uc5d0 \ub300\ud574\uc11c \ucacc \ubcf4\uace0 \uc788\ub294\ub370.. \uc2e0\uae30\ud55c \uc54c\uace0\ub9ac\uc998 \ubc1c\uacac.. word2Vec \uc774\ub77c\ub294 \uc54c\uace0\ub9ac\uc998\uc778\ub370.. \u00a0\ub9d0 \uadf8\ub300\ub85c.. \ub2e8\uc5b4\ub4e4\uc744 vector\uc5d0 \ub123\uc5b4\uc11c \uac80\uc0c9\uc5d0 \ud65c\uc6a9\ud55c\ub2e4\ub294 \uc598\uae30\uc774\ub2e4.. \ucc98\uc74c\uc5d0\ub294 \uadf8\ub0e5 \uad6c\ubb38 \ubd84\uc11d\uc5d0 \ubca1\ud130\ub97c \uc368\uc11c \ubb58 \ud55c\ub2e4\ub294 \uac74\uac00?? \ud588\ub294\ub370.. \uadf8\uac8c \uc544\ub2c8\uace0.. \uac01 \ub2e8\uc5b4\ub4e4\uc744 \uc2e0\uacbd\ub9dd \ud559\uc2b5\uc73c\ub85c \ube44\uc2b7\ud55c \ub2e8\uc5b4\ub07c\ub9ac \ubca1\ud130 \uac70\ub9ac \u00a0( vector distance )\ub77c\ub294 \uc218\ud559 \uac12\uc744 \uc774\uc6a9\ud558\uc5ec \ube44\uc2b7\ud55c \ub2e8\uc5b4\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":427,"url":"https:\/\/blog.box.kr\/?p=427","url_meta":{"origin":425,"position":2},"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":1284,"url":"https:\/\/blog.box.kr\/?p=1284","url_meta":{"origin":425,"position":3},"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":174,"url":"https:\/\/blog.box.kr\/?p=174","url_meta":{"origin":425,"position":4},"title":"[VC++] Window\uc758 \ucd08\uae30 \ud06c\uae30\uc640 \uc704\uce58 \uc815\ud574\uc8fc\uae30","date":"2014-07-09","format":false,"excerpt":"Windows \uc6a9 \uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \uacbd\uc6b0\uc5d0, console \ud504\ub85c\uadf8\ub7a8\uc774 \uc544\ub2cc\uacbd\uc6b0\uc5d0\ub294 \uc2e4\ud589\uc2dc\uc5d0 window\uc758 \ucd08\uae30 \uc704\uce58\uc640 \ud06c\uae30\ub97c \uc815\ud574\uc8fc\uace0 \uc2f6\uc740 \uacbd\uc6b0\uac00 \uc788\uc744\uac83\uc774\ub2e4. \ub098\ub294 \uba87\uc77c\uc804\uc5d0 \uc788\uc5c8\ub2e4~ \uc27d\uac8c \ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud558\uace0\uc790 \ud55c\ub2e4. \uc6b0\uc120 \ucf54\ub4dc\ub97c \ub17c\ud558\uae30\uc5d0 \uc55e\uc11c\uc11c \ub0b4\uac00 \uc0ac\uc6a9\ud55c \ubc29\ubc95\uc744 \uac04\ub7b5\ud788 \uc124\uba85\ud558\uc790\uba74, MainFrame class\uc5d0 WM_SHOWWINDOW message\uc5d0 \ub300\ud55c event handler\ub97c \ub9cc\ub4e4\uc5b4\uc8fc\uc5b4 \uadf8 \uc548\uc5d0\uc11c WINDOWPLACEMENT structure\ub97c \uc774\uc6a9\ud588\ub2e4. void\u2026","rel":"","context":"In "C\/C++"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":379,"url":"https:\/\/blog.box.kr\/?p=379","url_meta":{"origin":425,"position":5},"title":"[\ud38c]\ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js","date":"2014-09-15","format":false,"excerpt":"http:\/\/bcho.tistory.com\/889 \ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js - #6 MongoDB \uc5f0\ub3d9 (mongo-native) \ud074\ub77c\uc6b0\ub4dc \ucef4\ud4e8\ud305 & NoSQL\/Vert.x & Node.js\u00a0|\u00a02014\/04\/03 23:49\u00a0|\u00a0Posted by\u00a0\uc870\ub300\ud611 \ube60\ub974\uac8c \ud6dd\uc5b4\ubcf4\ub294\u00a0node.js #6- mongo-native \ubaa8\ub4c8\uc744 \uc774\uc6a9\ud55c MongoDB \uc5f0\ub3d9 \uc870\ub300\ud611\u00a0(http:\/\/bcho.tistory.com Persistence\u00a0\uc5f0\ub3d9 node.js\ub294\u00a0DB\ub098\u00a0NoSQL\ub4f1\uc758 \uc5f0\ub3d9\uc744 \uc9c0\uc6d0\ud558\ub294\ub370,\u00a0\uc774 \uc5ed\uc2dc \ucca0\uc800\ud558\uac8c\u00a0non-blocking io\u00a0\ubc29\uc2dd\uc73c\ub85c \ub3d9\uc791\ud55c\ub2e4.\u00a0\uc989\u00a0db\u00a0\uc5f0\uacb0\u00a0socket\uc744 \uc5f4\uc5b4\uc11c\u00a0query\ub97c \ub358\uc838\ub193\uace0, query\u00a0\uacb0\uacfc\uac00 \uc624\uba74 \uc774\ubca4\ud2b8\ub97c \ubc1b\uc544\uc11c\u00a0callback\u00a0\ud568\uc218\ub85c \ucc98\ub9ac\ud558\ub294 \uc21c\uc11c\uc774\ub2e4. \uadf8\ub7ec\uba74 \uc5ec\uae30\uc11c\ub294 \uba87\uac00\uc9c0\u00a0persistence\u00a0\uc5f0\ub3d9 \ubc29\uc2dd\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud55c\ub2e4.\u2026","rel":"","context":"In "\ucc38\uace0\ub97c \uc704\ud55c \uc800\uc7a5\ubb3c"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/425"}],"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=425"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/425\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}