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.

Numeric functions

Numeric functions

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

Numeric 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 Numeric 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 number functions fit in with the rest, here's an overview of Single-Row Functions. They fall into five basic categories, character, numeric, date, and date arithmetic, conversion, and general. Some of the Conversion Functions and General Functions may technically fall into the number category, only because they return a number, but we'll cover those in a different lesson. Single-Row Functions return a Single-Row or Column Value for every row of the query. These functions can appear in five places, the SELECT clause, WHERE clause, the START WITH/CONNECT BY clause, the GROUP BY clause and the HAVING clause. Notice that some of these are conditional. You can…

Contents