SQL Functions in Oracle Database 10g

This course is included in our On-demand training solution.

Overview

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

180 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?