Oracle SQL Specifics Retrieving and Formatting Data 

... to convert a character string to a date format.
Use the
DECODE function to decode an expression.
Perform a query with a nested, single row function.
Match each group function to its description.
Use a group function to query a set of rows and display one result per group.
Use the
GROUP BY clause to divide query rows into smaller groups.
Unit 4:
Using SET Operators
Duration: 1
more...
Oracle SQL and SQL Plus Advanced SELECT Statements 

...rite correlated subqueries.
Write queries using number
DECODE and character functions.
Write hierarchical queries and format hierarchical reports.
Write compound queries by using set operators and control the order of the output of the compound queries.
C ontent
Emphasis
Skills-Based
A udience
Application developers, database administrators, system designer/developers,
more...