SQL Functions in Oracle9i

Overview/Description
To describe how to use SQL functions for data retrieval

Target Audience
Junior database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
300 Minutes

Objectives:

SQL Functions in Oracle9i

  • describe and use character, number, and date functions in SELECT statements in an Oracle9i database.
  • describe and use datatype conversion functions in SELECT statements in an Oracle9i database.
  • describe how to use nested and conditional functions in SELECT statements in an Oracle9i database.
  • use single-row functions in SELECT statements in an Oracle9i database.
  • use conversion functions to convert date values in SELECT statements.
  • explain how to retrieve data from multiple Oracle9i database tables using join methods.
  • describe how to retrieve data from multiple Oracle9i database tables using SQL: 1999 join syntax.
  • use SQL: 1999 joins to retrieve data from multiple tables in an Oracle9i database.
  • describe how to use SET operators to combine multiple queries into a single query using SET operators.
  • identify and to describe the use of group functions in an Oracle database.
  • describe and use the GROUP BY clause for an Oracle database.
  • use group functions and the GROUP BY clause in SELECT statements in an Oracle9i database.
  • identify and describe the use of GROUP BY enhancements in an Oracle9i database.
  • use GROUP BY enhancements in an Oracle9i database.
  • describe and use the new datetime functions in an Oracle9i database.


    • Course Number: 66472_eng