Oracle SQL Fundamentals/Conversion Functions

This lesson introduces conversion functions.

Objectives and Skills
Objectives and skills for the conversion functions portion of Oracle SQL Fundamentals I certification include:
 * Using Conversion Functions and Conditional Expressions
 * Describe various types of conversion functions that are available in SQL
 * Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Readings

 * 1) Read  Primitive data type.
 * 2) Read Oracle: Conversion Functions.
 * 3) Read Oracle: TO_CHAR (character).
 * 4) Read Oracle: TO_CHAR (number).
 * 5) Read Oracle: TO_CHAR (datetime).
 * 6) Read Oracle: TO_NUMBER.
 * 7) Read Oracle: TO_DATE.
 * 8) Read Oracle: Format Models.

Multimedia

 * 1) YouTube: Oracle SQL Tutorial - Querying a table - Part 10(e) - Single-Row Conversion Functions

Activities

 * 1) Test character conversion functions using HR data.
 * 2) Run the following query:
 * 3) Run the following query:
 * 4) Run the following query:
 * 5) Test date conversion functions using DUAL.
 * 6) Run the following query:
 * 7) Run the following query:
 * 8) Test number conversion functions using DUAL.
 * 9) Run the following query:
 * 10) Test character conversion functions using OE data.
 * 11) Select customer credit limit using different numeric formats.
 * 12) Select order date using different date formats.
 * 13) Test date conversion functions using DUAL.
 * 14) Select various character-based date formats and convert the values to dates.
 * 15) Test number conversion functions using DUAL.
 * 16) Select various character-based numeric formats and convert the values to numbers.

Lesson Summary

 * TO_CHAR (character) converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set. The value returned is always VARCHAR2.
 * TO_CHAR (n, [format]) converts n to a value of VARCHAR2 data type, using the optional number format.
 * TO_CHAR (datetime, [format]) converts a datetime or interval value of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL DAY TO SECOND, or INTERVAL YEAR TO MONTH data type to a value of VARCHAR2 data type in the format specified by the date format.
 * TO_NUMBER(expression, [format]) converts expression to a value of NUMBER data type. The expression can be a number value of CHAR, VARCHAR2, NCHAR, NVARCHAR2, BINARY_FLOAT, or BINARY_DOUBLE data type.
 * TO_DATE(char, [format]) converts char of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type to a value of DATE data type.

Assessments

 * Flashcards: Quizlet: Oracle 1Z0-051 Exam - Functions