Conversion Functions and Conditional Expressions

Introduction

Using Conversion Functions and Conditional Expressions

In this module you will explore the concepts of using the Conversion Functions and Conditional Expressions in relational tables using the SELECT statement.

• Conversion Functions Available in SQL
• Introduction to TOCHAR, TODATE and TO_NUMBER
• Apply Conditional Expressions in a SELECT statement

Exercise 1 - Conversion Functions Available in SQL

In this exercise, you will learn the following about the conversion functions and conditional expressions:

• Establishing a Connection to the Database
• Using Implicit Conversion
• Using Explicit Conversion
• Using Format Modifiers

Exercise 2 - Introduction to TOCHAR, TODATE and TO_NUMBER

In this exercise you will learn the following about conversion functions and conditional expressions:

• Various Uses of the TO_CHAR Function in a SELECT Statement
• Various Uses of the TO_DATE Function in a SELECT Statement
• Various uses of the TO_NUMBER Function in a SELECT Statement

Exercise 3 - Apply Conditional Expressions in a SELECT Statement

Conditional expressions provide SQL statements with the ability to perform IF-THEN-ELSE decisions. There are two conditional expressions that can be performed within the SQL in Oracle are CASE and DECODE.

In this exercise you will learn the following about conversion functions and conditional expressions:

• Using the CASE Statement
• Using the DECODE Statement