일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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
- it
- Gradle
- java
- ubuntu
- IntelliJ
- jsp
- AWS
- redis
- Web Server
- Spring
- linux
- Spring Boot
- laravel
- Design Patterns
- devops
- php
- db
- MySQL
- jenkins
- docker
- Git
- JPA
- elasticsearch
- tool
- javascript
- springboot
- Oracle
- ReactJS
- 맛집
- 요리
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