![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
SeanLiew
这个作者很懒,什么都没留下…
展开
-
mybatis+oracle批量插入,批量更新
mybatis+oracle批量插入,批量更新 入参list中为map或者Bean都行,返回为插入条数<insert id="saveList" parameterType="java.util.List"> insert into RISK_RECHARGES (RCR_ID, TASK_ID, TIME, AMOUNT, TYPE) select risk_原创 2017-11-29 11:02:54 · 1455 阅读 · 0 评论 -
oracle递归子查询因子化
用于多级别查询 递归子查询因子化 (Recursive Subquery Factoring, RSF)with son(lvl,user_name,user_id,parent_id) as(select 4,user_name,user_id,parent_id from user_profiles where user_id = 5union allselect son.lvl-1, p原创 2017-11-29 13:19:17 · 335 阅读 · 0 评论