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 · 693 阅读 · 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 · 917 阅读 · 0 评论