일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 |
Tags
- MySQL
- Spring Boot
- ReactJS
- 맛집
- Design Patterns
- 요리
- devops
- jsp
- Git
- tool
- redis
- java
- AWS
- db
- php
- Gradle
- springboot
- ubuntu
- it
- Spring
- jenkins
- javascript
- laravel
- elasticsearch
- JPA
- docker
- Oracle
- Web Server
- linux
- IntelliJ
Archives
- Today
- Total
목록2020/08 (2)
아무거나
[oracle] 버전별 페이징 쿼리 (mybatis 예시)
1. 12g 이전 버전 SELECT ROW_NUM, LOG_NO, SVC_NM, DB_NM, TBL_NM, PROCDR_NM, CALL_URL, CALL_MTHD_SP_VAL, CALL_PARA_VAL, EXEC_TME, LOG_DESC, INPT_DM FROM ( SELECT ROW_NUMBER () OVER (ORDER BY INPT_DM DESC) AS ROW_NUM, LOG_NO, SVC_NM, DB_NM, TBL_NM, PROCDR_NM, CALL_URL, CALL_MTHD_SP_VAL, CALL_PARA_VAL, EXEC_TME, LOG_DESC, INPT_DM FROM TB_CM_OP_L ) WHERE ROW_NUM BETWEEN ((NVL(1, 0)-1) * 10 + 1) AND (NVL(..
Data Store/DB
2020. 8. 19. 14:22