Saturday, May 5, 2018

Using MOD in PLSQL Query

https://randomsrsolutions.blogspot.com/2018/05/using-mod-in-plsql-query.html

The MOD Function Finds the Remainder of Value1 by Value2
Note: The MOD Function is often used to determine if a value is odd or Even

select
MOD(3,2),
MOD(10,2),
MOD(15,3),
MOD(52,6),
MOD(230,5)
from dual;


MOD(3,2)      MOD(10,2)         MOD(15,3)          MOD(52,6)              MOD(230,5)
              1                       0                          0                          4                                 0



No comments:

Post a Comment

XLA to GL Link

  https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT             acr.cash_receipt_id,             acr.receipt_number,       ...