Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gd-system-plugin domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the templatic domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114
MODULO

  • 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

© 2024 Explore Oracle Applications.