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 ObjectivesSQL 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