{"id":305,"date":"2015-01-19T16:31:39","date_gmt":"2015-01-19T08:31:39","guid":{"rendered":"http:\/\/www.llku.com\/?p=305"},"modified":"2015-01-23T10:58:18","modified_gmt":"2015-01-23T02:58:18","slug":"%e9%80%9a%e8%bf%87%e4%bc%a0%e5%85%a5%e7%9a%84%e5%ad%97%e7%ac%a6%e4%b8%b2%e5%b9%b6%e6%a0%b9%e6%8d%ae%e5%88%86%e9%9a%94%e7%ac%a6%e6%88%aa%e5%8f%96%e5%87%ba%e7%9b%ae%e6%a0%87%e5%ad%97%e7%ac%a6%e4%b8%b2","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=305","title":{"rendered":"\u901a\u8fc7\u4f20\u5165\u7684\u5b57\u7b26\u4e32\u5e76\u6839\u636e\u5206\u9694\u7b26\u622a\u53d6\u51fa\u76ee\u6807\u5b57\u7b26\u4e32"},"content":{"rendered":"

\n\t \u521a\u521a\u5199\u4e00\u63a5\u53e3\u7684\u65f6\u5019\uff0c\u5916\u56f4\u7cfb\u7edf\u9700\u8981\u4f20\u5165\u4e00\u4e2a\u5b57\u7b26\u4e32\u6765\u4f5c\u4e3a\u67e5\u8be2\u6761\u4ef6\u67e5\u8be2\u6570\u636e\uff0c\u6700\u540e\u7531\u8d22\u52a1\u7cfb\u7edf\u8fd4\u56de\u6570\u636e\u81f3\u5916\u56f4\u7cfb\u7edf\uff0c\u4f46\u4f20\u5165\u7684\u4e00\u4e2a\u53d8\u91cf\u6570\u636e\u662f\u4e00\u4e2a\u6574\u4f53\uff0c\u9700\u8981\u622a\u53d6\u83b7\u53d6\u76ee\u6807\u5b57\u7b26\u4e32\u624d\u80fd\u4f5c\u4e3a\u67e5\u8be2\u6761\u4ef6\uff0c\u4e8e\u662f\u5199\u4e00\u51fd\u6570\uff0c\u8bb0\u5f55\u4e8e\u6b64\u4ee5\u5907\u540e\u7528\uff1a\n<\/p>\n

\n\t–\u901a\u8fc7\u4f20\u5165\u7684\u5b57\u7b26\u4e32\u5e76\u6839\u636e\u5206\u9694\u7b26\u622a\u53d6\u51fa\u76ee\u6807\u5b57\u7b26\u4e32(\u5206\u9694\u7b26\u4e3a',',\u53ef\u81ea\u5b9a\u4e49\u5206\u9694\u7b26)\n<\/p>\n

\n\tdeclare
\n\t p_str varchar2(1000) := 'a,c,g';
\n\t l_count number := 0;
\n\t l_str varchar2(100); –\u76ee\u6807\u5b57\u7b26\u4e32\u6570\u636e
\n\tbegin
\n\t –\u9996\u5148\u83b7\u53d6\u5b57\u7b26\u4e32\u7279\u522b\u5b57\u7b26\u7684\u6570\u91cf
\n\t select nvl(length(regexp_replace(p_str, '[^,]', '')) + 1, 0)
\n\t into l_count
\n\t from dual;\n<\/p>\n

\n\t –\u5982\u679c\u53ea\u6709\u4e00\u4e2a\u5b57\u7b26\u6bb5\uff0c\u5219\u4e0d\u5904\u7406
\n\t if l_count = 0 then
\n\t dbms_output.put_line('Data: ' || p_str);
\n\t end if;
\n\t –\u5982\u679c\u6709\u591a\u4e2a\u5b57\u7b26\u6bb5\uff0c\u5219\u5206\u5272
\n\t if l_count <> 0 then
\n\t for i in 1 .. l_count loop
\n\t select regexp_substr(p_str, '[^,]+', 1, i) as str
\n\t into l_str
\n\t from dual;
\n\t dbms_output.put_line('Data' || i || ':' || l_str);
\n\t end loop;
\n\t end if;
\n\texception
\n\t when others then
\n\t dbms_output.put_line('error code :' || sqlcode);
\n\t dbms_output.put_line('error msg :' || sqlerrm);
\n\tend;<\/p>\n","protected":false},"excerpt":{"rendered":"