Substring Oracle Integration Cloud


Substring Oracle Integration Cloud

  1. In Oracle Integration Cloud (OIC), you can use the SUBSTRING function to extract a portion of a string. The SUBSTRING function is often used in expressions and mappings to manipulate data within integrations. Here’s the syntax for the SUBSTRING function in OIC:

    SUBSTRING(string_expression, start_position, length)

    • string_expression: The source string from which you want to extract a substring.
    • start_position: The position within the source string where you want to start extracting the substring. It is a numeric value, and the counting starts from 1.
    • length (optional): The number of characters to extract from the source string. If not specified, it will extract characters from the start_position to the end of the string.

    Here are some examples of how to use the SUBSTRING function in Oracle Integration Cloud:

    1. Extract a substring starting from the 4th character to the end of the string: SUBSTRING(‘Hello World’, 4) — Output: ‘lo World’
    2. Extract a substring starting from the 7th character with a length of 3 characters: SUBSTRING(‘Hello World’, 7, 3) — Output: ‘Wor’
    3. Extract a substring starting from the 2nd character to the end of the string: SUBSTRING(‘Integration’, 2) — Output: ‘ntegration’
    4. Extract a single character from a string (e.g., the 5th character): SUBSTRING(‘ABCDE’, 5, 1) — Output: ‘E’

Oracle Integration Cloud (OIC) Training Demo Day 1

You can find more information about Oracle Integration Cloud Service in this Oracle Docs Link



Unogeeks is the No.1 Training Institute for OIC. Anyone Disagree? Please drop in a comment

Please check our Oracle Integration Cloud Training Details here OIC Training

You can check out our other latest blogs on Oracle Integration Cloud in this OIC Blogs


💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *