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, 1616🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...