1.jdbcTemplate.update中的sql语句后用“;”结尾会报错sql语句为正确结束
2.oracle树状查询
SELECT ISC_ID FROM PMS_DEPT START WITH ISC_ID = ? CONNECT BY PRIOR ISC_ID = SJBMID
3.oracle分页查询 ROWNUM
由于ROWNUM是伪列而且不能取大于1的数,所以先查出子集,再把子集和ROWNUM伪列拼成一个新的子集,再用rownum的别名过滤,具体写法如下:
SELECT
*
FROM
(
SELECT
temp.* ,
ROWNUM num
FROM
( SELECT POWERDISTRIBUTIONACCOUNT_EQUIPMENT AS equipment, POWERDISTRIBUTIONACCOUNT_PANORAMA AS panorama, POWERDISTRIBUTIONACCOUNT_CABINETDOOR AS cabinetDoor, POWERDISTRIBUTIONACCOUNT_REMARKS AS remarks FROM "ACCOUNT_EQUIPMENT" WHERE PLAN_ID = '1619576896611' ) temp
)
WHERE
num <= 10
AND num >= 2