From the course: Oracle Database 19c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Conversion functions

Conversion functions

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

Conversion functions

“

- [Instructor] Database single-row built-in functions can be divided into several categories: character, number, date, conversion and the catch-all general. I'll give a detailed overview of the conversion single-row functions in this video and how they are used in the select statement or any SQL statement for that matter, to see how conversion statements fit in with the rest, here's an overview. They fall into five basic categories: character, numeric, date and date arithmetic, conversion and general. Some of the conversion functions can possibly be assigned to the number functions only because they return a number but we'll cover the general functions in a different lesson. If we have five categories, they have to go somewhere and there could be some overlap between the categories. And the conversion function's primary purpose is to convert one data type to another some of the target data types are numbers. Single-row functions return a single-row or column value for every row of the…

Contents