Online Compound Query eLearning
Compound Query Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle SQL Specifics Retrieving and Formatting Data

...onversion function to match the number and datatypes in a compound query.
Use the ORDER BY clause to sort a compound query.
Unit 5: Utilizing Subqueries
Duration: 1 Hour(s)
Perform a query with an embedded subquery.
Perform a query with a subquery embedded in a FROM clause.
Perform a query with a multiple column subquery.
Perform a query with a correlated subquery.
Use
more...
Oracle SQL Specifics Retrieving and Formatting Data
Oracle SQL and SQL Plus Advanced SELECT Statements

...d queries by using the different set operators.
Write a compound query that displays a set of rows returned by any set of queries within it.
Write a compound query that displays the common rows returned by the queries within it.
Write a compound query that displays all the rows returned by the first query and not by the second query.
Identify the rules that must be followed when using
more...
Oracle9i SQL Data Retrieval Techniques

...ntify guidelines for using the SET operators. o Create a compound query that uses the UNION operator to combine data from two results sets. o Create a compound query that uses the INTERSECT operator to combine data from two results sets. o Create a compound query that uses the MINUS operator to combine data from two results sets. o Identify the four Oracle join types used to display data
more...
