{"id":428,"date":"2015-09-03T00:24:16","date_gmt":"2015-09-03T00:24:16","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=428"},"modified":"2015-09-03T00:24:16","modified_gmt":"2015-09-03T00:24:16","slug":"cursorsharing-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=428","title":{"rendered":"cursor_sharing \ud30c\ub77c\ubbf8\ud130"},"content":{"rendered":"<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\uc624\ub77c\ud074 \uc5d0\uc11c \uac1c\ubc1c\uc790\uac00 \uc2e4\ud589\ud558\ub294 SQL\ubb38\uc774 \uc7ac\ud30c\uc2f1\ub418\uc9c0 \uc54a\uae30 \uc704\ud574\uc11c\ub294 \ubc18\ub4dc\uc2dc \ub3d9\uc77c\ud55c SQL\ubb38\uc774 \uc2e4\ud589\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc870\uac74\uc740 \ub3d9\uc77c\ud55c\ub370 \uc870\uac74\uc808\uc758 \uc0c1\uc218 \uac12\uc774 \ud2c0\ub9b0 \uacbd\uc6b0 \ub610\ub294 \ubc14\uc778\ub4dc\ubcc0\uc218\uc758 \uac12\uc774 \ud2c0\ub9b0 \uacbd\uc6b0\uc5d0\ub3c4 \ub3d9\uc77c\ud55c SQL\ubb38\uc73c\ub85c \uc778\uc815\ub418\uc9c0 \uc54a\uc544 \uc7ac\ud30c\uc2f1\uc744 \ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc774 \ubc1c\uc0dd\ud558\uc600\uc2b5\ub2c8\ub2e4.&nbsp;<span style=\"line-height: 19.2000007629395px; font-size: 9pt;\">\uc624\ub77c\ud074 \uc5d0\uc11c\ub294 \ub3d9\uc77c\ud55c SQL\ubb38\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c cursor_sharing \ud30c\ub77c\uba54\ud130\ub97c \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><strong style=\"letter-spacing: 0px;\"><u>1.CURSOR_SHARING = EXACT<\/u><\/strong><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><strong style=\"letter-spacing: 0px;\"><u><\/u><\/strong>&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \uc0ac\uc6a9\ub41c SQL\ubb38\uc774 \ubaa8\ub450 \ub3d9\uc77c\ud55c \uc870\uac74\uc744 \uac00\uc838\uc57c\ub9cc \ud30c\uc2f1 \uc815\ubcf4\ub97c \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">WHERE \uc870\uac74\uc5d0 \uc815\uc758\ub41c \uc0c1\uc218\uac00 \ub3d9\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\uac00. select * from dept where deptno = 30;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\ub098. select * from dept where deptno = 40;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><font color=\"#ff0000\">==&gt; \uc2e4\ud589\ub41c 2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \ub300\ud55c \ud30c\uc2f1 \uc815\ubcf4\uac00 \uac01\uac01 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/font><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><strong style=\"letter-spacing: 0px;\"><u>2.CURSOR_SHARING = FORCE<\/u><\/strong><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \uc0ac\uc6a9\ub41c SQL\ubb38\uc774 \ubaa8\ub450 \ub3d9\uc77c\ud574\uc57c \ud30c\uc2f1 \uc815\ubcf4\ub97c \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e8,WHERE \uc870\uac74\uc5d0 \uc815\uc758\ub41c \ubc14\uc778\ub4dc \ubcc0\uc218\uac00 \uac01\uac01 \ub2e4\ub978 \uac12\uc744 \uac00\uc9c0\uace0 \uc788\ub354\ub77c\ub3c4 \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\uac00.select * from dept where deptno = 10;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\ub098.select * from dept where deptno = 12;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><font color=\"#ff0000\">==&gt; \uc2e4\ud589\ub41c 2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \ub300\ud55c \ud30c\uc2f1 \uc815\ubcf4\uac00 \ud558\ub098\ub9cc \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/font><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><strong style=\"letter-spacing: 0px;\"><u>3.CURSOR_SHARING = SIMILAR<\/u><\/strong><\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><strong style=\"letter-spacing: 0px;\"><u><\/u><\/strong>&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \uc0ac\uc6a9\ub41c SQL\ubb38\uc774 \ubaa8\ub450 \ub3d9\uc77c\ud574\uc57c \ud30c\uc2f1 \uc815\ubcf4\ub97c \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e8, WHERE\uc870\uac74\uc5d0 \uc815\uc758\ub41c \uc0c1\uc218\uac00 \ub2e4\ub974\ub354\ub77c\ub3c4 \ucee4\uc11c\ub97c \uacf5\uc720\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\uac00.select * from dept where deptno = 10;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">\ub098.select * from dept where deptno = 12;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\">&nbsp;<\/p>\n<p style=\"margin: 0px; word-wrap: normal; word-break: normal; font-family: \uad74\ub9bc, gulim, tahoma, sans-serif; line-height: 19.2000007629395px; background-color: rgb(249, 248, 243);\"><font color=\"#ff0000\">==&gt; \uc2e4\ud589\ub41c 2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \ub300\ud55c \ud30c\uc2f1 \uc815\ubcf4\uac00 \ud558\ub098\ub9cc \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074 \uc5d0\uc11c \uac1c\ubc1c\uc790\uac00 \uc2e4\ud589\ud558\ub294 SQL\ubb38\uc774 \uc7ac\ud30c\uc2f1\ub418\uc9c0 \uc54a\uae30 \uc704\ud574\uc11c\ub294 \ubc18\ub4dc\uc2dc \ub3d9\uc77c\ud55c SQL\ubb38\uc774 \uc2e4\ud589\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc870\uac74\uc740 \ub3d9\uc77c\ud55c\ub370 \uc870\uac74\uc808\uc758 \uc0c1\uc218 \uac12\uc774 \ud2c0\ub9b0 \uacbd\uc6b0 \ub610\ub294 \ubc14\uc778\ub4dc\ubcc0\uc218\uc758 \uac12\uc774 \ud2c0\ub9b0 \uacbd\uc6b0\uc5d0\ub3c4 \ub3d9\uc77c\ud55c SQL\ubb38\uc73c\ub85c \uc778\uc815\ub418\uc9c0 \uc54a\uc544 \uc7ac\ud30c\uc2f1\uc744 \ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc774 \ubc1c\uc0dd\ud558\uc600\uc2b5\ub2c8\ub2e4.&nbsp;\uc624\ub77c\ud074 \uc5d0\uc11c\ub294 \ub3d9\uc77c\ud55c SQL\ubb38\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c cursor_sharing \ud30c\ub77c\uba54\ud130\ub97c \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. &nbsp; 1.CURSOR_SHARING = EXACT &nbsp; 2\uac1c\uc758 \ubb38\uc7a5\uc5d0 \uc0ac\uc6a9\ub41c SQL\ubb38\uc774 \ubaa8\ub450 \ub3d9\uc77c\ud55c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[21],"tags":[188],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/428"}],"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=428"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}