Group and Datetime Functions in Oracle Database 10g
This course is included in our On-demand training solution.
To demonstrate how to use group and datetime functions in Oracle 10g
Database administrators, application developers, and database operators
Familiarity with RDBMS technologies and programming techniques
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.