2022年8月31日
oracle 把查询出的列转换成行并按逗号分隔
摘要： select listagg (id, ',') WITHIN GROUP (ORDER BY id) id from tableName start with id = xxx connect by prior id = fat_id; 阅读全文
posted @ 2022-08-31 18:17 小秦的开发梦 阅读(95) 评论(0) 推荐(0)
oracle 查询树结构数据
摘要： select * from tableName start with id = xxx connect by prior id = pid; 阅读全文
posted @ 2022-08-31 18:15 小秦的开发梦 阅读(30) 评论(0) 推荐(0)