Collections:
Arithmetic Operations in Pl/SQL in Oracle
What Are the Arithmetic Operations in Oracle?
✍: 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;
⇒ Numeric Comparison Operations in Oracle
⇐ Assign Values to Variables in Oracle
2018-08-06, 1606🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...