insert when (not exists (select DEPT_ID from T_JY_WX_DEPT where DEPT_ID = ?)) then into T_JY_WX_DEPT (DEPT_ID,DEPT_NAME,PROJECT_ALIAS,PARENT_ID) values(?,?,?,?) select ? from dual
oracle插入之前判断是否存在
最新推荐文章于 2024-01-24 16:50:23 发布