V43 - Oracle SQL Tutorial - Subqueries in Oracle (Hands-On)
Loading...
Loading...
9,888
Loading...
Uploader Comments (oraclecoach)
see all
All Comments (8)
-
thanks... for the videio.
-
hey excellent voice and presentation. :)
-
Hi oraclecoach,
How about an example of a multiple column subquery particularly inline view or temporary table with IN where clause.
-
thanx gr8 tutorial
-
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?
Loading...
11:09
V44 - Oracle SQL Tutorial - Data Dictionary (Theory)by oraclecoach6,439 views- 12:45
V1-Oracle Database Concepts - Part 1by oraclecoach27,604 views
- 10:28
V37 - Oracle SQL Tutorial - Joining Tables (Hands-on) - Part 1by oraclecoach10,151 views
- 13:24
A8 - Oracle SQL Tutorial - Managing Roles (Hands-On)by oraclecoach4,331 views
- 9:03
A37 - Oracle Administration Tutorial - Understanding Tablespaces and Datafiles (Theory)by oraclecoach6,530 views
- 10:00
V3 - Oracle SQL Tutorial - Creating a table (Theory)by oraclecoach16,045 views
- 9:11
V47 - Oracle Administration Tutorial - Categories of Data Dictionary Views (Theory)by oraclecoach7,084 views
- 8:10
A10 - Oracle Administration Tutorial - Oracle Server Basics (Part 2)by oraclecoach8,452 views
- 6:09
A9 - Oracle Administration Tutorial - Oracle Server Basics (Part 1)by oraclecoach10,342 views
- 10:26
A4 - Oracle SQL Tutorial - Data Control Language- System Privileges (Hands-On)by oraclecoach5,342 views
- 6:39
V2 - Oracle Database Concepts - Part 2by oraclecoach11,697 views
- 12:57
A6 - Oracle SQL Tutorial - Object Privileges (Hands-On)by oraclecoach3,782 views
- 7:53
V21 - Oracle SQL Tutorial - Querying data - Part 4 - (ORDER BY clause)by oraclecoach6,346 views
- 6:11
V22 - Oracle SQL Tutorial - Querying data - Part 5 - DISTINCT clauseby oraclecoach4,817 views
- 8:42
A20 - Oracle Administration Tutorial - Starting up a Database (Hands-On)by oraclecoach5,655 views
- 6:44
V28 - Oracle SQL Tutorial - Querying data - Part 10(b) - Single-Row Character Functionsby oraclecoach4,421 views
- 3:58
V12 - Oracle SQL Tutorial - Creating an Indexby oraclecoach6,002 views
- 14:00
V31 - Oracle SQL Tutorial - Querying a table - Part 10(e) - Single-Row Conversion Functionsby oraclecoach5,259 views
- 12:22
PL10 - PL/SQL Tutorial - DML and TCL statements (Hands-On)by oraclecoach5,812 views
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!
oraclecoach 1 year ago
for the Neena example...I got Steven King as the result...Hope am right!!!
kollyajax 1 year ago
@kollyajax
Yes that is perfectly right...good job!
oraclecoach 1 year ago