"오라클 lateral 조인"의 두 판 사이의 차이
DB CAFE
(새 문서: https://oracle-base.com/articles/12c/lateral-inline-views-cross-apply-and-outer-apply-joins-12cr1#lateral-inline-views) |
|||
| 1번째 줄: | 1번째 줄: | ||
https://oracle-base.com/articles/12c/lateral-inline-views-cross-apply-and-outer-apply-joins-12cr1#lateral-inline-views | https://oracle-base.com/articles/12c/lateral-inline-views-cross-apply-and-outer-apply-joins-12cr1#lateral-inline-views | ||
| + | |||
| + | == LATERAL == | ||
| + | <SOURCE LANG=SQL> | ||
| + | SELECT department_name, employee_name | ||
| + | FROM departments d | ||
| + | , LATERAL (SELECT employee_name | ||
| + | FROM employees e | ||
| + | WHERE e.department_id = d.department_id | ||
| + | ); | ||
| + | </SOURCE> | ||
2019년 5월 23일 (목) 07:58 판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
LATERAL[편집]
SELECT department_name, employee_name
FROM departments d
, LATERAL (SELECT employee_name
FROM employees e
WHERE e.department_id = d.department_id
);