Скачать или смотреть Addition, subtract, division, and multiply + NVL in oracle SQL [for beginners]

Arithmetic operators in Oracle SQL are Addition, subtraction, multiple and divide, in these examples we will use add and multiply, and show you how to user nvl when we have null values and apply the addition.

Arithmetic operators rules in Oracle SQL
Multiplication and division take priority over addition and subtraction.
Operators of the same priority are evaluated from left to right.
Parentheses are used to force prioritized evaluation and to clarify statements.

✅ Sql math.
Chapters:
00:00 Intro
00:08 using Addition in SQL.
00:38 how to use alias table in SQL.
01:01 arithmetic operators rules in SQL.
01:38 how to use multiple in SQL.
02:45 how to use NVL with null values.

Arithmetic Expressions SQL tutorial Examples:

✅ Example 1:
SELECT last_name, salary, 12*salary+100
FROM employees;

✅ Example 2:
SELECT last_name, salary, 12*(salary+100)
FROM employees;

✅ Example 3:
SELECT last_name, job_id, salary, commission_pct
FROM employees;

✅ Example 4:
SELECT last_name, salary , nvl(commission_pct,0) +500
FROM employees;

✅ To install sample database on you database, please check this video:
   • How to install Oracle Sample Database sche...  

✅ How to become oracle expert
https://erpscope.com/how-to-become-or...

✅ Oracle database download link:
https://www.oracle.com/kw/database/te...

✅ linkedin :   / posts  

✅Facebook:   / erpscope  

✅ Twitter:   / erp_scope  

✅Instagram:   / erp_scope  

✅ Youtube:    / @erpscope