{"id":301,"date":"2022-03-31T16:11:06","date_gmt":"2022-03-31T08:11:06","guid":{"rendered":"https:\/\/www.tianjm.cn\/?p=301"},"modified":"2022-03-31T16:11:06","modified_gmt":"2022-03-31T08:11:06","slug":"informatica-sql-%e8%bd%ac%e6%8d%a2-%e8%b8%a9%e5%9d%91","status":"publish","type":"post","link":"https:\/\/www.tianjm.cn\/?p=301","title":{"rendered":"informatica Sql \u8f6c\u6362 \u8e29\u5751"},"content":{"rendered":"\n<p>\u7531\u4e8e\u4e0a\u6e38\u7cfb\u7edf\u4f20\u9012\u7684\u57ce\u5e02\u540d\u79f0\u4e0d\u6807\u51c6\uff0c\u5bfc\u81f4\u65e0\u6cd5\u548c\u4e0b\u6e38\u7cfb\u7edf\u5339\u914d\u3002<\/p>\n\n\n\n<p>\u4f8b\uff1a\u4e0a\u6e38\u4f20\u9012\u7684\u662f \u201c\u7ea2\u6cb3\u201d\uff0c\u4e0b\u6e38\u7cfb\u7edf\u6570\u636e\u5e93\u5b58\u7684\u662f\u201c\u4f0a\u7281\u54c8\u8428\u514b\u81ea\u6cbb\u5dde\u201d<\/p>\n\n\n\n<p>\u4e3a\u4e86\u89e3\u51b3\u8fd9\u4e2a\u96be\u9898\uff0c\u81ea\u7136\u5c31\u5f97\u7528\u4e0aSql\u8f6c\u6362\u5668\uff0c\u91c7\u7528like\u7684\u65b9\u5f0f\u3002<\/p>\n\n\n\n<p>\u56fe\u6807\u662f\u8fd9\u6837\u7684<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"493\" height=\"62\" src=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image.png\" alt=\"\" class=\"wp-image-303\" srcset=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image.png 493w, https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-300x38.png 300w\" sizes=\"(max-width: 493px) 100vw, 493px\" \/><\/figure>\n\n\n\n<p>\u7136\u540e\u914d\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u6211\u624d\u7528\u7684\u662f\u9759\u6001\u94fe\u63a5\uff0c\u67e5\u8be2\u6a21\u5f0f\uff0c\u5e76\u5728SQL\u67e5\u8be2\u4e2d\uff0c\u6309\u4e0b\u56fe\u914d\u7f6e\u597dlike\u8bed\u53e5\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"710\" height=\"144\" src=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-304\" srcset=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-1.png 710w, https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-1-300x61.png 300w\" sizes=\"(max-width: 710px) 100vw, 710px\" \/><\/figure>\n\n\n\n<p>\u6ce8\u610fSQL\u67e5\u8be2<\/p>\n\n\n\n<p>SELECT CITY_ID FROM CSO_OWNER.M_CITY where city_name LIKE &#8216;%&#8217;||?city_name?||&#8217;%&#8217; AND ROWNUM =1\uff0c<\/p>\n\n\n\n<p>\u8fd9\u91cc\u4e00\u5b9a\u8981\u6309\u7167 LIKE &#8216;%&#8217;||?city_name?||&#8217;%&#8217; \u6765\u62fc\u63a5\uff0c ?city_name? \u4e3a\u8f93\u5165\u53c2\u6570\uff0c<\/p>\n\n\n\n<p>\u5426\u5219\uff0c\u67e5\u51fa\u6765\u7684\u6570\u636e\u5c31\u662f\u7a7a\u7684\uff0c\u4e4b\u524d\u6211\u662f\u8fd9\u6837\u5199\u7684\uff0c\u67e5\u8be2\u4e0d\u51fa\u6765<\/p>\n\n\n\n<p> \u9519\u8bef\u5199\u6cd5\uff1aSELECT CITY_ID FROM CSO_OWNER.M_CITY where city_name LIKE &#8216;%?city_name?%&#8217; AND ROWNUM =1 <\/p>\n\n\n\n<p>\u6700\u540e\u8fd8\u9700\u8981\u518d\u4f1a\u8bdd\u4e2d\uff0c\u8bbe\u7f6e\u6570\u636e\u5e93\u7684\u8fde\u63a5<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"799\" height=\"411\" src=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-2.png\" alt=\"\" class=\"wp-image-306\" srcset=\"https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-2.png 799w, https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-2-300x154.png 300w, https:\/\/www.tianjm.cn\/wp-content\/uploads\/2022\/03\/image-2-768x395.png 768w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/figure>\n\n\n\n<p>\u8bb0\u5f55\u4e0b\uff0c\u4eca\u5929\u53c8\u8e29\u4e00\u5751\u3002\u3002\u3002\u3002\u3002\u3002\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7531\u4e8e\u4e0a\u6e38\u7cfb\u7edf\u4f20\u9012\u7684\u57ce\u5e02\u540d\u79f0\u4e0d\u6807\u51c6\uff0c\u5bfc\u81f4\u65e0\u6cd5\u548c\u4e0b\u6e38\u7cfb\u7edf\u5339\u914d\u3002 \u4f8b\uff1a\u4e0a\u6e38&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/posts\/301"}],"collection":[{"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":4,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":308,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/308"}],"wp:attachment":[{"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tianjm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}