Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using the MOD Function

740706Dec 21 2009 — edited Dec 21 2009
Can someone explain to me the syntax of the MOD function. In my Oracle9i book it states "The MOD function find the remainder of value1 divided by value2.

In a simple sql statement I ran from my test db. For the life of me I cannot see where any division takes place.

select employee_id, last_name, first_name, salary, mod(salary, 500)
from employees;

EMPLOYEE_ID LAST_NAME FIRST_NAME SALARY MOD(SALARY,500)
100 King Steven 24000 0
101 Kochhar Neena 17000 0
102 De Haan Lex 17000 0
103 Hunold Alexander 9000 0
104 Ernst Bruce 6000 0
105 Austin David 4800 300
106 Pataballa Valli 4800 300
107 Lorentz Diana 4200 200
108 Greenberg Nancy 12000 0
109 Faviet Daniel 9000 0
110 Chen John 8200 200
111 Sciarra Ismael 7700 200
112 Urman Jose Manuel 7800 300
113 Popp Luis 6900 400
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2010
Added on Dec 21 2009
4 comments
1,064 views