摘要:
Oracle: <update id="createNew" statementType="STATEMENT" parameterType="java.util.Map"> begin ${sql} end; </update> 注意:必须有begin end;不然会报 ORA-00933: SQ 阅读全文
摘要:
oracle 分页: 关键字ROWNUM SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM ( SELECT A.*, ROWNUM RN FROM (SELECT EMPNO, ENAME, JOB, MGR, TO_C 阅读全文