Conversion Functions and Conditional Expressions
"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...

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
See the full benefits of our immersive learning experience with interactive courses and guided career paths.