Oracle PL/SQL - What Are the Arithmetic Operations

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

What Are the Logical Operations
What Are the Logical Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports 3 logical operations as shown in the following sample script: PROCEDURE proc_comparison AS x BOOLEAN := TRUE; y BOOLEAN := FALSE; res BOOLEAN; BEGIN res = x AND y; res = x OR y; res = NOT x; -- m... 2007-04-30, 4821👍, 0💬

How To Assign Values to Variables
How To Assign Values to Variables? - Oracle DBA FAQ - Understanding PL/SQL Language Basics You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script b... 2007-04-30, 4744👍, 0💬

What Are the Numeric Comparison Operations
What Are the Numeric Comparison Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports 6 basic numeric comparison operations as shown in the following sample script: PROCEDURE proc_comparison AS res BOOLEAN; BEGIN res := 1 = 2; res := 1 2; res := 1 = 2; res := 1 2; -- mo... 2007-04-30, 4623👍, 0💬

What Are the Arithmetic Operations
What Are the Arithmetic Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics 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; BEG... 2007-04-30, 4585👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.