What Are the Arithmetic Operations

Q

What Are the Arithmetic Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: 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;

2007-04-30, 4487👍, 0💬