SQL Functions in Oracle Database 10g


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



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

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.0

Lesson Objectives

SQL Functions in Oracle Database 10g

  • use case and character-manipulation functions in SQL statements.
  • use number and date functions in SQL statements.
  • use number, character, and date functions to manipulate data values.
  • identify the purpose of SQL datatype conversion functions in Oracle 10g.
  • use the TO_CHAR conversion function with dates and numbers.
  • use the TO_NUMBER and TO_DATE conversion functions.
  • use conversion functions to convert values in SQL statements.
  • use general functions in SQL statements.
  • use conditional expressions in SQL statements.
  • use general and conditional functions in SQL statements.
  • Course Number:
    216206_eng