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, 619👍, 0💬

Popular Posts:

How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

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