Creating a Function

• Console
• CLI
• API

• 1. From the list of function libraries on the User-defined functions page, select the name of the library in which you want to create and save a function.

     If you need help finding the User-defined functions page, see Listing Function Libraries.

  2. In the Functions section of the library details page, select Create function.
  3. In the Create user defined function panel, enter the following details:
     • Name: Enter a name for the function.
     • Identifier: The identifier is a system-generated value based on the function name that you enter. You can change the value, but after you save the function, you can't update the identifier.
     • Description: Enter a description for the function.
     • Return data type: Select a data type from the list.
     • In library: The name of the library in which you're creating the function. To change the library, select Edit and select a library in the Edit library location dialog box.
  4. To use an input parameter in this function, first add the parameter as follows:
     1. In the Expression builder section, select Input parameters.

        If a parameter that you want to use is already added, it's listed under Input parameters. You can skip to step 7.

     2. From the Actions menu, select Add input parameters.
     3. In the Add input parameters panel, enter a name and description for the parameter that you want to add, and select a data type for it.
     4. To add another parameter, select Additional parameter and enter the parameter information. Repeat the procedure to add more parameters.
     5. When you have finished adding the parameters that you want to use in this function, select Add.

        The parameters are listed under Input parameters in the Expression builder section.

  5. In the Expression builder section, to create the expression for this function, double-click or drag an element from the Functions or Input parameters list to add the element to the editor. You can also manually write or edit the expression.
     1. On the Functions tab, expand the function category to find the function that you want to use.
     2. On the Input parameters tab, find the input parameters to build the expression. For example, for a function to calculate tax, you might have added input parameters for base salary (base), flexible benefits (flexi), and deductions (deductions). To build the expression, drag those input parameters to form the expression as base + flexi - deductions.
     3. To validate the expression, select Validate.
  6. Select Create.

     The user-defined function that you created is listed in the Functions section of the library details page.

• Use the oci data-integration user-defined-function create command and required parameters to create a function:

  Copy

  oci data-integration user-defined-function create [OPTIONS]

  For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

• Run the CreateUserDefinedFunction operation to create a function.