{"id":964,"date":"2021-01-20T00:28:44","date_gmt":"2021-01-19T15:28:44","guid":{"rendered":"https:\/\/skyit.biz\/?p=964"},"modified":"2021-01-25T01:40:44","modified_gmt":"2021-01-24T16:40:44","slug":"%e7%ac%ac3%e7%ab%a0%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e5%88%b6%e9%99%90%e3%81%8a%e3%82%88%e3%81%b3%e3%82%bd%e3%83%bc%e3%83%88","status":"publish","type":"post","link":"https:\/\/skyit.biz\/?p=964","title":{"rendered":"\u7b2c3\u7ae0\t\u30c7\u30fc\u30bf\u306e\u5236\u9650\u304a\u3088\u3073\u30bd\u30fc\u30c8"},"content":{"rendered":"\n<p>\u25a0ORDER BY\u53e5<br>\u4f7f\u7528\u3059\u308b\u5217\u540d\u3092SELECT\u53e5\u306b\u542b\u3081\u308b\u3053\u3068\u306f\u3001\u5fc5\u9808\u3067\u306f\u306a\u3044\u3002<br>\u6587\u5b57\u306e\u30bd\u30fc\u30c8\u306f\u3001\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3059\u308b\u3002<br>\u30bd\u30fc\u30c8\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u3001NULL\u5024\u306f\u3001\u6700\u5927\u5024\u3068\u3057\u3066\u6271\u308f\u308c\u308b\u3002<br>NULLS FIRST\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u3068\u3001NULL\u5024\u3092\u6700\u5c0f\u5024\u3068\u3057\u3066\u30bd\u30fc\u30c8\u3059\u308b\u3002<br>NULLS LAST\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u3068\u3001NULL\u5024\u3092\u6700\u5927\u5024\u3068\u3057\u3066\u30bd\u30fc\u30c8\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u65e5\u4ed8 DESC \u65b0\u3057\u3044\u65e5\u9806\u306b\u4e26\u3076\u3002\u65e5\u4ed8\u964d\u9806<br>\u65e5\u4ed8 ASC \u53e4\u3044\u65e5\u9806\u306b\u4e26\u3076\u3002\u65e5\u4ed8\u6607\u9806<\/p>\n\n\n\n<p>FETCH\u53e5<\/p>\n\n\n\n<p>\u65e5\u4ed8\u30ea\u30c6\u30e9\u30eb\u306f\u3001\u66f8\u5f0f\u304c\u533a\u5225\u3055\u308c\u308b\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u65e5\u4ed8\u66f8\u5f0f\u306f\u3001DD-MON-RR\u3067\u3042\u308b\u3002<br>WHERE\u53e5\u3067\u306f\u3001\u5217\u5225\u540d\u306f\u4f7f\u3048\u306a\u3044\u3002ORDER BY\u53e5\u306f\u3001\u5217\u5225\u540d\u3092\u5229\u7528\u3067\u304d\u308b\u3002<br>\u6587\u5b57\u30ea\u30c6\u30e9\u30eb\u306e\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u306f\u533a\u5225\u3055\u308c\u308b\u3002\u4f8b\uff09&#8217;scott&#8217;\u3068&#8217;SCOTT&#8217;\u306f\u540c\u4e00\u3067\u306f\u306a\u3044\u3002<br>\u6587\u5b57\u30ea\u30c6\u30e9\u30eb\u3068\u65e5\u4ed8\u30ea\u30c6\u30e9\u30eb\u306f\u3001\u4e00\u91cd\u5f15\u7528\u7b26&#8221;\u3067\u56f2\u3080\u5fc5\u8981\u304c\u3042\u308b\u3002\u4f8b\uff09&#8217;SCOTT&#8217;\u3084&#8217;30-AUG-14&#8242;<\/p>\n\n\n\n<p>ESCAP<\/p>\n\n\n\n<p>SELECT ID, HEISU FROM EMP<br>WHERE ID LIKE &#8216;%A_B%&#8217; ESCAPE &#8216;\\&#8217;<\/p>\n\n\n\n<p>_\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u306f\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u6587\u5b57\u3068\u3057\u3066\u6271\u308f\u308c\u3066\u3057\u307e\u3046\u306e\u3067\u3001ESCAPE\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u3001\u6587\u5b57\u30ea\u30c6\u30e9\u30eb\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n\n\n\n<p>WHERE LIKE &#8216;%A_B%&#8217;<br>\u4e0a\u8a18\u306f\u3001AAB\u306a\u3069\u3082\u691c\u7d22\u3057\u3066\u3057\u307e\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"540\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2021\/01\/3_1.png\" alt=\"\" class=\"wp-image-965\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2021\/01\/3_1.png 901w, https:\/\/skyit.biz\/wp-content\/uploads\/2021\/01\/3_1-300x180.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2021\/01\/3_1-768x460.png 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/figure>\n\n\n\n<p>\u6bd4\u8f03\u6f14\u7b97\u5b50\uff1c\uff1e\u3092\u4f7f\u3046\u3068\u3001NULL\u5024\u306f\u691c\u7d22\u5bfe\u8c61\u5916\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<p>\u25a0\u7f6e\u63db\u5909\u6570<br>&amp; SQL\u6587\u306e\u5b9f\u884c\u6642\u306b\u7f6e\u304d\u63db\u3048\u308b\u5024\u306e\u5165\u529b\u304c\u8981\u6c42\u3055\u308c\u308b\u3002<br>\u6307\u5b9a\u3057\u305f\u5909\u6570\u306f\u3001SQL\u6587\u306e\u5b9f\u884c\u5f8c\u306b\u7834\u68c4\u3055\u308c\u308b\u3002<br>&amp;&amp; SQL\u6587\u306e\u5b9f\u884c\u6642\u306b\u7f6e\u304d\u63db\u3048\u308b\u5024\u306e\u5165\u529b\u304c\u8981\u6c42\u3055\u308c\u308b\u3002<br>\u6307\u5b9a\u3057\u305f\u5909\u6570\u306f\u3001SQL\u6587\u306e\u5b9f\u884c\u5f8c\u3082\u4fdd\u6301\u3055\u308c\u308b\uff08SQL * Plus\u3092\u7d42\u4e86\u3059\u308b\u307e\u3067\uff09<\/p>\n\n\n\n<p>SET VERIFY ON \u7f6e\u63db\u5f8c\u306e\u5024\u304c\u8868\u793a\u3055\u308c\u308b\u3002<br>SET VERIFY OFF \u7f6e\u63db\u5f8c\u306e\u5024\u3092\u8868\u793a\u3055\u305b\u306a\u3044\u3002<\/p>\n\n\n\n<p>\u25a0\u7f6e\u63db\u5909\u6570\u306e\u6d88\u53bb\u306b\u3064\u3044\u3066<br>SQL Devleloper\u3092\u30ed\u30b0\u30a2\u30a6\u30c8\u3059\u308b<br>UNDEFINE\u30b3\u30de\u30f3\u30c9\u3067\u5909\u6570\u3092\u89e3\u9664\u3059\u308b\u3002 \uff08UNDEFINE \u7f6e\u63db\u5909\u6570\u540d\uff09<br>DEFINE NAME = \u5225\u306e\u5024<br>\u5024\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u3001\u7f6e\u304d\u63db\u3048\u304c\u53ef\u80fd\u3002<\/p>\n\n\n\n<p>\u25a0SQL\u884c\u5236\u9650<br>\u884c\u5236\u9650\u306f\u3001ORDER BY\u53e5\u306e\u5f8c\u308d\u306b\u6307\u5b9a\u3059\u308b\u3002<br>\u884c\u5236\u9650\u306f\u3001ORDER BY\u53e5\u3068\u5fc5\u305a\u4e00\u7dd2\u306b\u4f7f\u308f\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u308f\u3051\u3067\u306f\u306a\u3044\u3002<br>OFFSET\u53e5 \u884c\u5236\u9650\u3092\u958b\u59cb\u3059\u308b\u524d\u306b\u30b9\u30ad\u30c3\u30d7\u3059\u308b\u884c\u6570\u3092\u6307\u5b9a\u3059\u308b\u3002 NULL\u6307\u5b9a\u306e\u5834\u5408\u3001\u884c\u306f\u623b\u3055\u308c\u306a\u3044\u3002<br>FETCH\u53e5 \u623b\u3055\u308c\u308b\u884c\u6570\u307e\u305f\u306f\u3001\u884c\u306e\u5272\u5408\u3092\u6307\u5b9a\u3059\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u25a0ORDER BY\u53e5\u4f7f\u7528\u3059\u308b\u5217\u540d\u3092SELECT\u53e5\u306b\u542b\u3081\u308b\u3053\u3068\u306f\u3001\u5fc5\u9808\u3067\u306f\u306a\u3044\u3002\u6587\u5b57\u306e\u30bd\u30fc\u30c8\u306f\u3001\u5927\u6587\u5b57\u3068\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3059\u308b\u3002\u30bd\u30fc\u30c8\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u3001NULL\u5024\u306f\u3001\u6700\u5927\u5024\u3068\u3057\u3066\u6271\u308f\u308c\u308b\u3002NULLS FIRST\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u3068 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":965,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52,12],"tags":[],"class_list":{"0":"post-964","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-bronze-sql-12c","8":"category-oracle"},"_links":{"self":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=964"}],"version-history":[{"count":1,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/964\/revisions"}],"predecessor-version":[{"id":966,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/964\/revisions\/966"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/media\/965"}],"wp:attachment":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}