프로그래밍/Oracle SQL (19) 썸네일형 리스트형 오라클 조인해서 UPDATE하기 UPDATE RC_AGGREGATION AGG_T SET AGG_T.MANAGEMENT_DEPT_UUID = (SELECT USER_GROUP_UUID FROM AC_USER_GROUP_HIST GS_T WHERE GS_T.PREVIOUS_USER_GROUP_UUID = AGG_T.MANAGEMENT_DEPT_UUID AND MAIN_DEPT_YN = 'Y' AND REG_YEAR = 2019 AND REG_SEQ = 1) WHERE EXISTS(SELECT 0 FROM AC_USER_GROUP_HIST GS_T WHERE GS_T.PREVIOUS_USER_GROUP_UUID = AGG_T.MANAGEMENT_DEPT_UUID AND MAIN_DEPT_YN = 'Y' AND REG_YEAR = 2019 .. 오라클 START WITH CONNECT BY 구문 ㅇ정순 SELECT * FROM A START WITH 부모_UUID IS NULL CONNECT BY PRIOR 자식_UUID = 부모_UUID ㅇ역순 SELECT * FROM A START WITH 자식_UUID = '고유값' CONNECT BY PRIOR 부모_UUID= 자식_UUID https://playdata.io/tutorials/sql/%EC%98%A4%EB%9D%BC%ED%81%B4-start-with-connect-by 오라클 START WITH CONNECT BY — 플레이데이터 오라클 START WITH CONNECT BY — 플레이데이터 playdata.io [ oracle ] SET DEFINE OFF - 특수문자 인서트시 문자열로 인식하기 https://bestit.kr/sprt/blog/sprtBlogPost.pem?blogSeq=326 오라클 버퍼 비우기 Clear Oracle's buffer_cache: alter system flush buffer_cache;Clear Oracle's shared_pool: alter system flush shared_pool; 출처 : https://www.avisi.nl/blog/2012/12/11/consistent-performance-testing-with-oracle-is-it-possible 오라클에서 group_concat https://medium.com/@jin5140/mysql-group-concat-%EC%98%A4%EB%9D%BC%ED%81%B4%EC%97%90%EC%84%9C%EB%8A%94-6685de4d61c5 EXPLAIN PLAN http://www.gurubee.net/lecture/1540 오라클 조인 https://hunit.tistory.com/225 쿼리 실행 순서(SELECT 구문) https://jdm.kr/blog/91 이전 1 2 3 다음