---
title: "Discussion on \"Introduction to JOIN LATERAL on Oracle\" | Hashnode"
description: "Discussion on \"Introduction to JOIN LATERAL on Oracle\". Lateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f..."
url: "https://hashnode.com/posts/introduction-to-join-lateral-on-oracle/6754746a9e093ce2ff4eb9db"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Introduction to JOIN LATERAL on Oracle](https://blog.srecnik.info/introduction-to-join-lateral-on-oracle?utm_source=hashnode&utm_medium=feed)

Lateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f...

Dec 7, 2024 · 4 min read · blog.srecnik.info  
Read the article

-   [#oracle](https://hashnode.com/tag/oracle)
-   [#joins](https://hashnode.com/tag/joins)
-   [#execution-plan](https://hashnode.com/tag/execution-plan)

## Written by

[Urh Srecnik](https://hashnode.com/@usrecnik)

@usrecnik

  
[View profile](https://hashnode.com/@usrecnik)

Oracle DBA

DBA Team Lead and Oracle ACE Pro. Building database tools and helping teams manage Oracle infrastructure.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
