What Are the Arithmetic Operations

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

✍: FYIcenter.com

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

Popular Posts:

Macro vs. Function...

Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...

Can you explain Form...

Can you explain Forms authentication in detail ? In old ASP if you where said to create a login page...

How To Change the Pa...

How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...

Where do you specify...

.NET INTERVIEW QUESTIONS - Where do you specify session state mode in ASP.NET ? The following code e...

Virtual Functions in...

Can you have virtual functions in Java? Yes, all functions in Java are virtual by default. This is a...