Group and Datetime Functions in Oracle Database 10g


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To demonstrate how to use group and datetime functions in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.2

Lesson Objectives

Group and Datetime Functions in Oracle Database 10g

  • retrieve data using group functions.
  • write SQL queries that group and restrict output rows.
  • write SQL queries that use group functions, the GROUP BY clause, and the HAVING clause
  • use the ROLLUP and CUBE operations and the GROUPING function in SQL queries.
  • use the GROUPING SETS function and specify composite columns and concatenated grouping sets.
  • write queries using ROLLUP and CUBE operators, GROUPING functions, and GROUPING SETS.
  • set time zone values and retrieve date and time values.
  • use date-related datatypes.
  • use date-related functions in Oracle 10g.
  • write SQL queries using datetime functions.

    • Course Number:
    216205_eng