Arithmetic Operations in Pl/SQL in Oracle

Q

What Are the Arithmetic Operations in Oracle?

✍: FYIcenter.com

A

There are 4 basic arithmetic operations on numeric values as shown in the following sample script:

PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEGIN addition := 7 + 8; subtraction := addition - 7; multiplication := subtraction * 5; division := multiplication / 8; -- division should contain 5 now END;

2018-08-06, 560👍, 0💬

Popular Posts:

How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......

Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...

Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...