Joins
Oracle supports ANSI joins and its older (+) syntax.
What you will be able to do
- Prefer ANSI JOIN syntax.
- Use LEFT JOIN for optional rows.
- Check execution plans.
In plain English
Oracle supports ANSI joins and its older (+) syntax.
- Prefer ANSI JOIN syntax.
- Use LEFT JOIN for optional rows.
- Check execution plans.
SELECT c.title, l.title
FROM courses c
LEFT JOIN lessons l ON l.course_id = c.id;Your turn
EasyExplain it back
Answer from memory: Which join syntax is preferred today?
TEXT · starter
Your answer…Check your understanding before moving on.
Knowledge checkQuestion 1
Which join syntax is preferred today?
Select an answer to continue
Study tools
Make it yours.
Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.
Sign in to save notes and flashcards.Both are private to your account and stay with your progress.
Sign inFinished reading?
Lock in what you just learned.
0%
Mark this lesson complete to save your place and move one step closer to the certificate.