What Is Numeric in Oracle SQL?

You use numeric functions to find data in a database.

Oracle SQL (Structured Query Language) is a programming language used to send commands to databases (in this case, Oracle databases). You use functions to query or manipulate the data within these databases.

Function Types

Oracle databases have two function types: single row and group. Single row functions will give you a value for each row you process when running a query. Group functions organize the data depending on the values generated by a query. Typically, you would use these to determine averages or total values.

Numeric Functions

Numeric functions are number-only single-row functions. You enter a number in your query and get a number in return.

Considerations

Since numeric functions are single-row, you use them only for simple queries with answers that do not require sorting or any kind of computation.

References

• Oracle SQL Functions: Beginner SQL Tutorial
• Key Functions in Oracle SQL
• Oracle/SQL Tutorial