\uc624\ub77c\ud074\u00a0DB\uc5d0\u00a0\uc608\ub97c\ub4e4\uc5b4\u00a0‘\uac00\ub098\ub2e4’\uc640\u00a0\uac19\uc774\u00a0\uc785\ub825\ub41c\u00a0\uc790\ub8cc\ub97c\u00a0 1 \ubd80\ud130\u00a05\uae4c\uc9c0\u00a0substrb \ud558\uace0\uc790\u00a0\ud560\u00a0\uacbd\uc6b0\u00a0‘\uac00\ub098’ \ub9cc\u00a0 return \ud558\ub294\u00a0\ud568\uc218<\/p>\n
<\/p>\n
create or replace function sf_hansubb( v_str in varchar2,\r\n v_start in integer,\r\n v_len in integer)\r\nreturn varchar2\r\n\/*==================================================================*\r\n * +---------------------------------------------------------+ *\r\n * | \ud504\ub85c\uadf8\ub7a8 ID : sf_hantrim.sql | *\r\n * +---------------------------------------------------------+ *\r\n * | \ud504\ub85c\uadf8\ub7a8 \uba85 : \ud55c\uae00 field right trim | *\r\n * +---------------------------------------------------------+ *\r\n * | \ud504\ub85c\uadf8\ub7a8 \uc124\uba85 | *\r\n * +---------------------------------------------------------+ *\r\n * | \ud55c\uae00 \uc790\ub8cc\uc911 KSC5601\uc5d0 \uc5c6\ub294 \ud55c\uae00\uc790\ub8cc\ub97c rihgt trim\ud55c\ub2e4 | *\r\n * | \ucc38\uace0\uc790\ub8cc : KSC5601 code table | *\r\n * +---------------------------------------------------------+ *\r\n *==================================================================*\/\r\nis\r\nl_len number(4);\r\nl_ascii number;\r\nl_down number;\r\nbegin\r\n if v_start = 0 then \r\n return null;\r\n end if;\r\n if v_len = 0 then \r\n return null;\r\n end if;\r\n if v_start > lengthb(v_str) then \r\n return null;\r\n end if;\r\n \r\n if v_len > (lengthb(v_str) - v_start + 1) then\r\n l_len := lengthb(v_str) - v_start + 1;\r\n else\r\n l_len := v_len;\r\n end if;\r\n \r\n if ascii(substrb(v_str,v_start + l_len - 1, 1)) = 32 then\r\n if l_len = 1 then \r\n return substrb(v_str,v_start,l_len);\r\n end if;\r\n l_ascii := ascii(substrb(v_str,v_start + l_len - 2, 2));\r\n if l_ascii >= 45217 and l_ascii <= 51454 then\r\n l_down := mod(l_ascii,256);\r\n if l_down >= 161 and l_down <= 254 then\r\n return substrb(v_str,v_start,l_len);\r\n else\r\n return substrb(v_str,v_start,l_len - 1);\r\n end if;\r\n else\r\n return substrb(v_str,v_start,l_len - 1);\r\n end if;\r\n else\r\n return substrb(v_str,v_start,l_len);\r\n end if;\r\nend sf_hansubb ;\r\n\r\n<\/pre>\n<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc624\ub77c\ud074\u00a0DB\uc5d0\u00a0\uc608\ub97c\ub4e4\uc5b4\u00a0‘\uac00\ub098\ub2e4’\uc640\u00a0\uac19\uc774\u00a0\uc785\ub825\ub41c\u00a0\uc790\ub8cc\ub97c\u00a0 1 \ubd80\ud130\u00a05\uae4c\uc9c0\u00a0substrb \ud558\uace0\uc790\u00a0\ud560\u00a0\uacbd\uc6b0\u00a0‘\uac00\ub098’ \ub9cc\u00a0 return \ud558\ub294\u00a0\ud568\uc218 create or replace function sf_hansubb( v_str in varchar2, v_start in integer, v_len in integer) return varchar2 \/*==================================================================* * +———————————————————+ * * | \ud504\ub85c\uadf8\ub7a8 ID : sf_hantrim.sql | * * +———————————————————+ * * | \ud504\ub85c\uadf8\ub7a8 \uba85 : \ud55c\uae00 field right trim | * * +———————————————————+ * * | […]<\/p>\n","protected":false},"author":1,"featured_media":2880,"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":[3],"tags":[965,966],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/tips-newsletter.jpg?fit=680%2C530","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3226"}],"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=3226"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3226\/revisions"}],"predecessor-version":[{"id":3227,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3226\/revisions\/3227"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2880"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3226"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}