- 3,723,806 Users
- 2,244,620 Discussions
- 7,850,715 Comments
- 3 Introduce Yourself!
- 141 Community Feedback - NEW! (No Product Questions)
- 60 General Community Platform Concerns/Kudos/Feedback
- 51 Community Platform Bug Reports
- 63 How Do I Use the Community?
- 12 Where is the...? (Community Platform Locations)
- 9 Ideas and Suggestions for the Community Platform
- 65 Personal Document & Blog Archive
- 2 Community Programs
- 2 Get-Togethers
- 82 Certification Community
- 4.7K Certification Community Discussions
- 32 Oracle Certified Master Profiles
- 26 Oracle Database 12c Administrator Certified Master Profiles
- 32 Visual Builder Cloud Service
1Z0-071 - I'm very confused about what version of Oracle Database serves as the judge, jury and exec
I've been studying some test material to prepare for taking, and hopefully passing, the 1Z0-071 OCA exam. I came across a question asking me whether it was valid to execute a scalar subquery in a HAVING clause. And my first instinct was, "Of Course you can". But as I was discussing this with another person they suggested that it is not valid. So, I tried it in SQL*Plus on my local system. Version 22.214.171.124.0. And it works. This prompted further investigation into the situation. Later, I discovered that in the sql language reference manual version 12c that scalar subquerys were restricted in the HAVING clause. I looked in sql language reference manual version 19c and I see 2 less restrictions and 1 restriction has been modified. Of course, it's the GROUP BY ... HAVING ... clause that has been modified to just the GROUP BY clause.
So, my question is very simple, when I'm taking my Oracle 1Z0-071 on exam day, what version of Oracle's database am I ... actually being tested on ... ???