Tutorial#51 How to use modulus function in Oracle SQL Database| MOD Function in SQL

Explaining how to get mod of column/number in oracle database
MOD function returns the remainder of m divided by n or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use modulus function in SQL or what is the numeric function oracle SQL database
-----------------------------------------------------------------------------------------------
Assignment link:
------------------------------------------------------------------------------------------------------

SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

[pmtaurus]

You should explain what mod function calculates and how rather than just saying that mod is used to calculate mod from any number. Mod calculates the remainder of any number when divided by the second number in the syntax.

[syedsabeer]

4th one:
select 'XXX'||mod(deptno, 2)||'XXX' as "After_mod" from employee1;

[syedsabeer]

3rd question query is it right sir?
select '****'||mod(salary, 5), salary as "After_mod" from employee1;

[syedsabeer]

6th question is it correct sir?
select mod(power(salary, 2), 10) from employee1;

[vipuldhole]

Sir I have solved third question ans. by below query
select lpad((mod(salary, 5)), '3', '*'), salary from employees;
is it ok

[nehajha]

Sir, what is the answer for 4th and 5th?