\n\tselect created_by, translate(ltrim(text, '\/'), '*\/', '*,') researcherlist
\n\t from (select row_number() over(partition by created_by order by created_by, lvl desc) rn,
\n\t created_by,
\n\t text
\n\t from (select created_by,
\n\t level lvl,
\n\t sys_connect_by_path(c_researcher_code, '\/') text
\n\t from (select created_by,
\n\t user_name as c_researcher_code,
\n\t row_number() over(partition by created_by order by created_by, user_name) x
\n\t from fnd_user
\n\t order by created_by, user_name) a
\n\t connect by created_by = prior created_by
\n\t and x – 1 = prior x))
\n\t where rn = 1
\n\t order by created_by;\n<\/p>\n
\n\tSQL\u5206\u6790\uff1a<\/span>\n<\/p>\n \n\t1\u3001\u5229\u7528 “ROW_NUMBER () OVER (PARTITION BY……” \u4e3a\u6309“\u521b\u5efa\u4eba”\u6c47\u603b\u540e\u7684\u6570\u636e\u884c\u6dfb\u52a0\u7ec4\u5185\u5e8f\u53f7<\/span>\n<\/p>\n \n\t2\u3001“SYS_CONNECT_BY_PATH” \u6309\u7ec4\u5185\u5e8f\u53f7\u76f8\u90bb\u5173\u7cfb\uff0c\u4e3a\u6bcf\u4e00\u5c42\u8fdb\u884c\u4e0d\u540c\u884c\u7684“\u540d\u79f0”\u53e0\u52a0<\/span>\n<\/p>\n \n\t3\u3001\u518d\u6b21\u5229\u7528“<\/span>\u521b\u5efa\u4eba”\u8fdb\u884c\u7ec4\u5185\u5206\u7ec4\uff0c\u4f46\u6309\u7b2c\u4e8c\u90e8\u4e2d\u7684\u5c42\u6b21\u6392\u5012\u5e8f\uff0c\u589e\u52a0\u8c03\u6574\u540e\u7b49\u7ea7<\/span>\n<\/p>\n \n\t4\u3001\u53d6\u6240\u6709\u8c03\u6574\u540e\u7b49\u7ea7\u4e3a1\u7684\u7ed3\u679c\uff0c\u5373\u4e3a\u6240\u8981\u6c42\u7684\u6570\u636e\u884c<\/span>\n<\/p>\n \n\t\u5176\u4ed6\u53c2\u8003\uff1a<\/span>http:\/\/www.ningoo.net\/html\/2008\/how_to_do_string_aggregate_on_oracle.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" select created_by, translate(ltrim(text, '\/'), … \u7ee7\u7eed\u9605\u8bfbOracle PLSQL \u884c\u5408\u5e76<\/span>