Collections:

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;

**⇒** Numeric Comparison Operations in Oracle

**⇐** Assign Values to Variables in Oracle

2018-08-06, 1780🔥, 0💬

Popular Posts:

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...

What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...

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

Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...