![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
H愚公移山H
欲带皇冠,必承其重!!
展开
-
ORACLE 行转列
最近遇到行转列的问题需要将同一个id下面的数据组装起来与另一张主表中的数据组成一一条数据sql代码如下SELECT * FROM SE_REQ_ITEM_INFO srii LEFT JOIN ( SELECT ENTITY_ID, CASE WHEN attr_id = '201' THEN value END "201", CASE WHEN attr_id = 202 THEN value END "202",CASE WHEN attr_id = 203 THEN v原创 2020-11-17 17:52:42 · 460 阅读 · 0 评论 -
Oracle CLOB字段的处理
public static Map<String, Object> clobToStringByMap(Map<String, Object> map) {if (map == null) {return map;}for (Map.Entry<String, Object> entry : map.entrySet()) {Object t1 = entry.getValue();if (t1 instanceof Clob) {// 将所有Clob类型的字原创 2020-11-08 15:05:21 · 303 阅读 · 0 评论