Returns the minimum value of the element in the set. The datatype of the returned value is DATE. SYSDATE returns the current date and time. Use the TO_CHAR function to translate a value of NUMBER datatype to VARCHAR2 datatype. All occurrences of string_to_replace will be replaced with replacement_string in string1.įunction to_number converts char, a value of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype containing a number in the format specified by the optional format model fmt, to a value of NUMBER datatype. String_to_replace is the string that will be searched for in string1.

String1 is the string to replace a sequence of characters with another set of characters. The replace function replaces a sequence of characters in a string with another set of characters. Length is the number of characters to extract. The first position in the string is always 1. Start_position is the position for extraction. The substr function allows you to extract a substring from a string. Nth appearance is the nth appearance of string2. If the start_position is negative, the function counts back start_position number of characters from the end of string1 and then searches towards the beginning of string1. Start_position is the position in string1 where the search will start. String2 is the substring to search for in string1. The instr function returns the location of a substring in a string. Result is the value returned, if expression is equal to search.ĭefault is returned if no matches are found. Search is the value that is compared against expression. The syntax for the decode function is:ĭecode(expression, search, result. The decode function has the functionality of an IF-THEN-ELSE statement. Pad_string is the string that will be padded to the right-hand side of string1 String1 is the string to pad characters to (the right-hand side). The rpad function pads the right side of a string with a specific set of characters. Pad_string is the string that will be padded to the left-hand side of string1. Padded_length is the number of characters to return. String1 is the string to pad characters to (the left-hand side). The lpad function pads the left side of a string with a specific set of characters. The supported functions are shown in the following table: SQL Statement or XSL Expression For example, assume you had two elements, FIRST_NAME and LAST_NAME that you wanted to concatenate into a 30-character field and right pad the field with the character 'x', you could NOT use the following:īecause concat is an XSL expression.

Note: You cannot mix xdofx statements with XSL expressions in the same context. The syntax for these extended functions is Oracle Business Intelligence Publisher User's GuideĮxtended Function Support in RTF Templates Extended SQL and XSL FunctionsīI Publisher has extended a set of SQL and XSL functions for use in RTF templates. Skip Headers Oracle Business Intelligence Publisher User's Guide

Concatenate in rtf template