ITPub博客

oracle树形菜单查询参考http://space.itpub.net/10159839/viewspace-584603[@more@]select * from(select t.function_id,lpad(t.function_name,length(t.function_name)*2+(level-1)*2,'->'),t.function_name,t.parent_id,t.order_,t.fun_state,t.function_type,level from base_function t START WITH t.function_id in(0) CONNECT BY PRIOR t.function_id=t.parent_idorder siblings by t.order_) ttwhere tt.fun_state=1 and tt.function_type=1

Oracle计算两个日期之间的天数[@more@]SELECT TRUNC(TO_DATE( '2011-03-01 ', 'YYYY-MM-DD ')-TO_DATE( '2011-01-01 ', 'YYYY-MM-DD ')) FROM DUAL考虑到月大和月小的情况，还有二月的情况

SELECT REGEXP_SUBSTR('1,2', '([^,]+)', 1, ROWNUM) str FROM DUAL CONNECT BY ROWNUM <(LENGTH(REGEXP_REPLACE('1,2', '[^,]', '')) + 2)[@more@]'1,2'是传过来的字符串最后结果为1,2

http://tech.it168.com/a2011/0608/1201/000001201666.shtml[@more@]