본문 바로가기

Tibero11

tibero 날짜 + 시간 select to_char(sysdate,'yyyy-MM-dd HH:mm:ss') from dual; 2022. 9. 21.
오라클 티베로 계층쿼리 정렬 SELECT department_id, LPAD(' ' , 3 * (LEVEL-1)) || department_name, LEVEL FROM departments START WITH parent_id IS NULL CONNECT BY PRIOR department_id = parent_id ORDER SIBLINGS BY department_name; 부분을 필요로 할 때는 SELECT department_id, LPAD(' ' , 3 * (LEVEL-1)) || department_name, LEVEL FROM departments START WITH 컬럼명 = 초기값 CONNECT BY PRIOR department_id = parent_id 2022. 9. 7.
티베로 페이징 속도 최적화 select X.rnum, X.id, X.name, X.content, X.createdate from ( select rownum as rnum, A.id, A.name, A.content, A.createdate from ( select id, name, content, createdate from board order by createdate) A where rownum = 21 [ select X.rn, X.* from ( select rownum as rn, A.* from ( select * from LETTNSAMPLEBOARD order by ntt_no) A where rownum = (#firstIndex#+1) ] DBMS 는 ROW NUMBER 을 부여하다가 위와 같이 첫번째 조건을.. 2022. 8. 26.

티스토리툴바