{"id":946,"date":"2015-12-29T14:02:44","date_gmt":"2015-12-29T14:02:44","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=946"},"modified":"2015-12-29T14:02:44","modified_gmt":"2015-12-29T14:02:44","slug":"sql-%ec%84%b1%eb%8a%a5-%ed%96%a5%ec%83%81-%ec%a7%80%ec%b9%a8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=946","title":{"rendered":"SQL \uc131\ub2a5 \ud5a5\uc0c1 \uc9c0\uce68"},"content":{"rendered":"

 <\/P>
\n

1.SQL <\/SPAN>\uc791\uc131\uc2dc \uc720\uc758\uc0ac\ud56d<\/SPAN><\/SPAN><\/P>
\n

<\/SPAN> <\/P>
\n

1.<\/SPAN>\uceec\ub7fc \uac00\uacf5\uc73c\ub85c \uc778\ud55c \ube44\ud6a8\uc728<\/SPAN><\/P>
\n

 <\/P>
\n

2.<\/SPAN>\ud655\uc778\uc790<\/SPAN>\/<\/SPAN>\uc81c\uacf5\uc790 \uc5ed\ud560\uc758 <\/SPAN>SubQuery<\/SPAN><\/P>
\n

 <\/P>
\n

3.<\/SPAN>\ucd5c\uc18c<\/SPAN>,<\/SPAN>\ucd5c\ub300\uac12<\/SPAN>(<\/SPAN>\ucd5c\ucd08<\/SPAN>,<\/SPAN>\ucd5c\uc885<\/SPAN>) <\/SPAN>\uad6c\ud558\uae30<\/SPAN><\/P>
\n

 <\/P>
\n

4.<\/SPAN>\ud568\uc218 <\/SPAN>\uc218\ud589\ud69f\uc218<\/SPAN> \ube44\ud6a8\uc728<\/SPAN><\/P>
\n

 <\/P>
\n

5.<\/SPAN>\ube48\ubc88\ud55c <\/SPAN>OCI CALL<\/SPAN>\uacfc <\/SPAN>LOOP QUERY<\/SPAN><\/P>
\n

 <\/P>
\n

6.<\/SPAN>\ubd80\ubd84\ubc94\uc704<\/SPAN> \ucc98\ub9ac<\/SPAN><\/P>
\n

 <\/P>
\n

7.<\/SPAN>\uc778\ub371\uc2a4 \ubd80\uc7ac<\/SPAN><\/P>
\n

 <\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

<\/P>
\n

\uc8fc\uc758\uc0ac\ud56d<\/SPAN><\/U><\/P>
\n

1.<\/SPAN>\uceec\ub7fc\uc744 \uac00\uacf5\ud558\uc9c0 \uc54a\uace0 <\/SPAN>SQL<\/SPAN>\uc791\uc131<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>(<\/SPAN>\ubd88\uac00\ud53c\ud558\uac8c \uceec\ub7fc\uc744 \uac00\uacf5\ud574\uc57c \ud558\ub294 \uacbd\uc6b0 <\/SPAN>\uadf9\ud76c<\/SPAN> \ud76c\ubc15<\/SPAN>)<\/SPAN><\/P>
\n

<\/P>
\n

2.<\/SPAN>\uceec\ub7fc\uacfc \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c <\/SPAN>\uc0c1\uc218\uac12\uc744<\/SPAN> \ube44\uad50\ud558\uace0 \ubcc0\uc218 \ubc14\uc778\ub529<\/SPAN><\/P>
\n

 <\/P>
\n

 <\/P>
\n

<\/P>
\n

<\/P>
\n

\uc8fc\uc758\uc0ac\ud56d<\/SPAN><\/U><\/P>
\n

1.SubQuery<\/SPAN>\uac00 \uc81c\uacf5\uc790 \uc5ed\ud560\uc744 \ud558\ub824\uba74 <\/SPAN>\uba54\uc778\ucffc\ub9ac<\/SPAN>    <\/SPAN>\uceec\ub7fc\uc774 <\/SPAN>SubQuery<\/SPAN>\uc5d0 \uc5c6\uc5b4\uc57c \ud568<\/SPAN>.<\/SPAN>\uc989<\/SPAN>, <\/SPAN>\uc81c\uacf5\uc790 \uc5ed\ud560\uc744 \uae30\ub300\ud55c <\/SPAN>SubQuery<\/SPAN>\uac00 <\/SPAN>\ud655\uc778\uc790<\/SPAN> \uc5ed\ud560\uc744 \ud558\uac8c \ub418\uba74 \uc2ec\uac01\ud55c \uc624\ubc84\ud5e4\ub4dc \ubc1c\uc0dd<\/SPAN><\/P>
\n

2.SubQuery <\/SPAN>\uc0ac\uc6a9\uc2dc <\/SPAN>M:M <\/SPAN>\uc5f0\uacb0\uc740 <\/SPAN>M:1<\/SPAN>\ub85c \uc5f0\uacb0\ub41c    <\/SPAN>\uacb0\uacfc \uc0dd\uc131<\/SPAN><\/P>
\n

3.KEY1 LIKE, KEY2 IN <\/SPAN>\ud615\ud0dc\uc758 \uc778\ub371\uc2a4 <\/SPAN>KEY1+KEY2<\/SPAN>\uc77c \uacbd\uc6b0 <\/SPAN>KEY2<\/SPAN>\uac00 <\/SPAN>IN<\/SPAN>\uc73c\ub85c \uc81c\uacf5\ub418\ub354\ub77c\ub3c4 \uc778\ub371\uc2a4   <\/SPAN>\uc120\ub450 \uceec\ub7fc\uc774 \u2018<\/SPAN>=\u2019 <\/SPAN>\uc774 \uc544\ub2c8\ubbc0\ub85c <\/SPAN>KEY2<\/SPAN>\ub294 \ub2e8\uc9c0 \uccb4\ud06c  <\/SPAN>\uae30\ub2a5\ub9cc \ub2f4\ub2f9<\/SPAN><\/P><\/SPAN>
\n

<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

<\/P>
\n

<\/P>
\n

\uc8fc\uc758 \uc0ac\ud56d<\/SPAN><\/U><\/P>
\n

1.<\/SPAN>\ucd5c\uc18c \ub610\ub294 \ucd5c\ucd08\ub294 \uc778\ub371\uc2a4\ub97c \uc624\ub984\ucc28\uc21c\uc73c\ub85c \uc77d\uc5b4 \uc870\uac74\uc5d0 \ub9de\ub294 \uccab \ubc88\uc9f8 \ub85c\uc6b0\uc5d0\uc11c \uba48\ucd98\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

<\/DIV>
\n

2.<\/SPAN>\ucd5c\ub300 \ub610\ub294 \ucd5c\uc885\uc740 \uc778\ub371\uc2a4\ub97c \ub0b4\ub9bc\ucc28\uc21c\uc73c\ub85c \uc77d\uc5b4 \uc870\uac74\uc5d0 \ub9de\ub294 \uccab \ubc88\uc9f8 \ub85c\uc6b0\uc5d0\uc11c \uba48\ucd98\ub2e4<\/SPAN>.<\/SPAN><\/P>
\n

   <\/SPAN>( INDEX_DESC <\/SPAN>\ud78c\ud2b8 \uc774\uc6a9<\/SPAN>)<\/SPAN>           <\/SPAN><\/SPAN><\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/SPAN> <\/P>
\n

<\/P>
\n

<\/P>
\n

\uc8fc\uc758\uc0ac\ud56d<\/SPAN><\/U><\/P>
\n

1)<\/SPAN><\/SPAN>\ud504\ub85c\uadf8\ub7a8 \ub610\ub294 \ud504\ub85c\uc2dc\uc838\uc5d0\uc11c \uc5ec\ub7ec \uac1c\uc758 \uc870\uac01 <\/SPAN>SQL<\/SPAN>\ub85c \ub098\ub258\uc5b4 \uc218\ud589\ub418\uace0 \uc788\ub294 <\/SPAN>SQL<\/SPAN>\ub4e4\uc744 \ucd5c\ub300\ud55c \ud1b5\ud569<\/SPAN><\/DIV>
\n
2)<\/SPAN><\/SPAN>LOOP QUERY <\/SPAN>\ub294 <\/SPAN>OCI CALL<\/SPAN>\ubd80\ud558\ub97c \ube44\ub86f\ud55c \ube44\ud6a8\uc728\uc744 \uc720\ubc1c\ud558\ubbc0\ub85c \uc9c0\uc591\ud558\uace0<\/SPAN>, ONE SQL<\/SPAN>\uc744 \uad6c\uc0ac
\n

 <\/P><\/SPAN><\/DIV><\/SPAN><\/SPAN><\/SPAN><\/p>\n","protected":false},"excerpt":{"rendered":"

  1.SQL \uc791\uc131\uc2dc \uc720\uc758\uc0ac\ud56d   1.\uceec\ub7fc \uac00\uacf5\uc73c\ub85c \uc778\ud55c \ube44\ud6a8\uc728   2.\ud655\uc778\uc790\/\uc81c\uacf5\uc790 \uc5ed\ud560\uc758 SubQuery   3.\ucd5c\uc18c,\ucd5c\ub300\uac12(\ucd5c\ucd08,\ucd5c\uc885) \uad6c\ud558\uae30   4.\ud568\uc218 \uc218\ud589\ud69f\uc218 \ube44\ud6a8\uc728   5.\ube48\ubc88\ud55c OCI CALL\uacfc LOOP QUERY   6.\ubd80\ubd84\ubc94\uc704 \ucc98\ub9ac   7.\uc778\ub371\uc2a4 \ubd80\uc7ac           \uc8fc\uc758\uc0ac\ud56d 1.\uceec\ub7fc\uc744 \uac00\uacf5\ud558\uc9c0 \uc54a\uace0 SQL\uc791\uc131   (\ubd88\uac00\ud53c\ud558\uac8c \uceec\ub7fc\uc744 \uac00\uacf5\ud574\uc57c \ud558\ub294 \uacbd\uc6b0 \uadf9\ud76c \ud76c\ubc15) 2.\uceec\ub7fc\uacfc \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \uc0c1\uc218\uac12\uc744 […]<\/p>\n","protected":false},"author":1,"featured_media":947,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[502],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile5.uf.214E353B5682912427D8EF.PNG?fit=750%2C473","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/946"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=946"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/946\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/947"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}