![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
bootstrap8
人不学 不知道
展开
-
oracle递归查询
一、从上到下 select level, id, parent_id, name, parent_name from table start with id = 1 connect by prior id = parent_id order by level; 二、从下到上 select level, id, parent_id, name, parent_name原创 2014-03-16 22:22:03 · 664 阅读 · 0 评论 -
Oracle语句块耗时
方法一: declare cnt number; b_time number; e_time number; begin cnt := 0; b_time := DBMS_UTILITY.GET_TIME; while cnt < 10 loop do something ...; commit; cnt := cnt + 1; e原创 2015-01-29 13:17:49 · 880 阅读 · 0 评论