• Menu
  • Home
  • Oracle Fusion
    • Creating a Party or Organization using REST API – Oracle Fusion
    • Create Customer Account, Site, Site Use using SOAP Webservice – Oracle Fusion
    • Create Customer Contact Point at Account Level using SOAP Webservice- Oracle Fusion
    • Adding an Email at Customer Contact Point using Webservice – Oracle Fusion
    • Update Receipt Method on AR Invoice
    • Update Customer Profile at Account Level using SOAP Webservice – Oracle Fusion
  • Oracle Technical
    • Oracle Triggers
    • Understanding UTL_FILE in Oracle PL/SQL
    • Cursors – Implicit Cursors
    • Cursors – Explicit Cursors
    • Create Table Scripts
    • DML Functions
      • SUBSTR
      • INSTR
      • INITCAP
      • LAST_DAY
      • ADD_MONTHS
      • NEXT_DAY
      • MONTHS_BETWEEN
      • MODULO
    • DECODE
    • Query to find Execution Method
    • Query to retrieve Concurrent Program Details
  • Oracle Products
    • Order Management
      • How To: Create a Sales Order
      • Oracle apps order error interface table
    • General Ledger
      • Query to derive the 4 C’s
    • Inventory
    • Payables
      • Oracle Payables Query
      • Understanding AP Invoice Interface
      • Oracle Payables Invoice Interface – Validate Vendor Number
      • Oracle Payables Invoice Interface – Validating Invoice Number
    • Receivables
      • Script to create a Cash Receipt using Oracle API (AR)
      • Script to Reverse an AR Receipt
      • Receipt Write-Off (AR) – Error Messages
      • Script to create a Receipt Write-off (AR)
      • Script to Create a Credit Memo (AR)
      • Script to create a Debit Memo (AR)
    • Purchasing
    • TCA Architecture
      • TCA Architecture
      • Customer, Party, Party Sites, Customer Sites, Site Uses
      • Create Customer using create_cust_account API
    • Banks in Oracle R12
  • Process Flow – P2P
    • Procure to Pay (P2P)
  • Python
    • Modify default browser to Chrome from Internet Explorer

Explore Oracle Applications

    • Home
    • Oracle Fusion
      • Creating a Party or Organization using REST API – Oracle Fusion
      • Create Customer Account, Site, Site Use using SOAP Webservice – Oracle Fusion
      • Create Customer Contact Point at Account Level using SOAP Webservice- Oracle Fusion
      • Adding an Email at Customer Contact Point using Webservice – Oracle Fusion
      • Update Receipt Method on AR Invoice
      • Update Customer Profile at Account Level using SOAP Webservice – Oracle Fusion
    • Oracle Technical
      • Oracle Triggers
      • Understanding UTL_FILE in Oracle PL/SQL
      • Cursors – Implicit Cursors
      • Cursors – Explicit Cursors
      • Create Table Scripts
      • DML Functions
        • SUBSTR
        • INSTR
        • INITCAP
        • LAST_DAY
        • ADD_MONTHS
        • NEXT_DAY
        • MONTHS_BETWEEN
        • MODULO
      • DECODE
      • Query to find Execution Method
      • Query to retrieve Concurrent Program Details
    • Oracle Products
      • Order Management
        • How To: Create a Sales Order
        • Oracle apps order error interface table
      • General Ledger
        • Query to derive the 4 C’s
      • Inventory
      • Payables
        • Oracle Payables Query
        • Understanding AP Invoice Interface
        • Oracle Payables Invoice Interface – Validate Vendor Number
        • Oracle Payables Invoice Interface – Validating Invoice Number
      • Receivables
        • Script to create a Cash Receipt using Oracle API (AR)
        • Script to Reverse an AR Receipt
        • Receipt Write-Off (AR) – Error Messages
        • Script to create a Receipt Write-off (AR)
        • Script to Create a Credit Memo (AR)
        • Script to create a Debit Memo (AR)
      • Purchasing
      • TCA Architecture
        • TCA Architecture
        • Customer, Party, Party Sites, Customer Sites, Site Uses
        • Create Customer using create_cust_account API
      • Banks in Oracle R12
    • Process Flow – P2P
      • Procure to Pay (P2P)
    • Python
      • Modify default browser to Chrome from Internet Explorer

MODULO

Posted by Phani Adivi on October 30, 2018 in Oracle Home

MODULO function returns the remainder value when a number (Dividend) is divided by another number (divisor).

Format: MOD (dividend, divisor).

Example1:

SELECT MOD (100, 9) FROM DUAL;

Result: 1

Example2:

SELECT MOD (-100, 9) FROM DUAL;

Result: -1

 

  • Twitter
  • Facebook
  • Google+
  • Pin It
  • LinkedIn
  • Email

Phani Adivi

Recent Posts

  • Update Customer Profile at Account Level using SOAP Webservice – Oracle Fusion February 26, 2022
  • Adding an Email at Customer Contact Point using Webservice – Oracle Fusion January 29, 2022
  • Create Customer Contact Point at Account Level using SOAP Webservice- Oracle Fusion January 29, 2022
  • Create Customer Account, Site, Site Use using SOAP Webservice – Oracle Fusion January 19, 2022
  • Creating a Party or Organization using REST API – Oracle Fusion January 14, 2022
  • Update Receipt Method on AR Invoice January 14, 2022
  • Modify default browser to Chrome from Internet Explorer March 4, 2021
  • Script to create a Cash Receipt using Oracle API (AR) February 5, 2019
  • Script to create a Receipt Write-off (AR) February 2, 2019
  • Receipt Write-Off (AR) – Error Messages February 2, 2019
  • Script to create a Debit Memo (AR) February 1, 2019
  • Script to Create a Credit Memo (AR) February 1, 2019
  • Query to derive the 4 C’s January 31, 2019
  • Oracle Payables Query January 31, 2019
  • Banks in Oracle R12 January 30, 2019
  • Procure to Pay (P2P) January 6, 2019
  • Process Flow – P2P January 5, 2019
  • Script to Reverse an AR Receipt November 9, 2018
  • DECODE November 6, 2018
  • Query to retrieve Concurrent Program Details October 30, 2018

© 2022 Explore Oracle Applications.