摘要:
原文位于:http://www.itpub.net/viewthread.php?tid=610297&extra=page%3D2%26amp%3Bfilter%3Ddigest&page=2把'a|||b|||c'字符串分隔成abccreate or replace function f_test(var_str in string) return t_ret_table is... 阅读全文
posted @ 2009-04-16 10:25
Good life
阅读(309)评论(0)推荐(0)
编辑
摘要:
原文位于:http://www.itpub.net/viewthread.php?tid=610297&extra=page%3D2%26amp%3Bfilter%3Ddigest&page=2create or replace type t_ret_table is table of varchar2(20);create or replace function f_test(v... 阅读全文
posted @ 2009-04-16 10:21
Good life
阅读(425)评论(0)推荐(0)
编辑
摘要:
/*Start with...Connect By子句的应用*//* 从树根往叶子递归 */select *from ( select '1' as id, '10' as name,'0' as pid from dual union all select '2','11','1' from dual union all select '3','20','0' from dual union... 阅读全文
posted @ 2009-03-10 11:56
Good life
阅读(174)评论(0)推荐(0)
编辑