Conversion Functions and Conditional Expressions

Practice Labs Module
Time
36 minutes
Difficulty
Intermediate

"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...

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

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
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.