V43 - Oracle SQL Tutorial - Subqueries in Oracle (Hands-On)

[krunal2347381]

thanks... for the videio.

[anubhavkhare13]

hey excellent voice and presentation. :)

[mikewang44]

Hi oraclecoach,

How about an example of a multiple column subquery particularly inline view or temporary table with IN where clause.

[faizan175]

thanx gr8 tutorial

[oraclecoach]

The usage of the IN operator is : in (value, value, value)

The usage of ANY is: =ANY which is the same as IN, "less than" ANY, "greater than" ANY

The usage of ALL is: "greater than" ALL, "less than" ALL

That is the syntax, you cannot write: ANY (value,..) or ALL(value...) without appending the "lessthan or greater than"

Hope this helps!

[kollyajax]

for the example on UK...I tried using the ANY and ALL operator in place of IN but I got errors messages why is that since they are suppose to work for multiple row result. Then I append the " less than and greater than" to the ANY and ALL operator...it worked...so does it mean that either the "less than or greater than" must be append to the operators before it can work?

[kollyajax]

for the Neena example...I got Steven King as the result...Hope am right!!!

[oraclecoach]

@kollyajax

Yes that is perfectly right...good job!