oracle
飞翔的羽翼
要以一个认真的态度做事情
展开
-
oracle行列转换(公式)
pivot纵表转横表select t2.姓名, t2.数学, t2.物理, t2.语文from Scores as t1pivot (sum(分数) for 课程 in(数学,语文,物理)) as t2unpivot 横表转纵表select * from 表名 unpivot (分数 for 课程 in (语文,数学,物理)) a...原创 2020-04-07 12:03:17 · 152 阅读 · 0 评论 -
mybatis针对oracle的批量插入
@Insert({"<script>", "INSERT INTO EV_OPT_WORK_CAR_RS (", "ID,", " CRT_USER_ID,", " CRT_TIME,", " WORK_ID,", " CAR_ID,...原创 2020-03-13 21:05:24 · 123 阅读 · 0 评论