![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
开航母的贝塔丶
你在,春华秋实夏蝉冬雪。你不在,春夏秋冬。
展开
-
【Mybatis】解决Oracle查询处理in条件超过1000条的问题
转:https://blog.csdn.net/changqing5818/article/details/84309562 select * from test_table where 1 = 1 <!-- IdList --> <if test="IdList != null and IdList.size > 0"> AND PK_ID IN ...转载 2019-05-30 10:16:28 · 2731 阅读 · 0 评论 -
Oracle sql 实现查询时将一个字符串按照","逗号分隔,返回分隔后的各个值
SELECT DISTINCT REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) as "result" FROM DUAL CONNECT BY REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) IS NOT NULL order by 1原创 2019-05-27 16:26:09 · 5105 阅读 · 0 评论