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

Popular Posts:

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...