In MariaDB, TRIM_ORACLE() is a synonym for the Oracle mode version of the TRIM() function.
TRIM_ORACLE() is available in all modes, so it saves you from having to switch to Oracle mode, which is what you’d need to do if you wanted the TRIM() function to behave like Oracle’s TRIM() function.
The difference is in how each function treats empty strings. Oracle returns null whereas MariaDB returns an empty string.
In MariaDB, LTRIM_ORACLE() is a synonym for the Oracle mode version of the LTRIM() function.
LTRIM_ORACLE() is available in all modes, so it saves you from having to switch to Oracle mode, which is what you’d need to do if you wanted the LTRIM() function to behave like Oracle’s LTRIM() function.
The difference is in how each function treats empty strings. Oracle returns null whereas MariaDB returns an empty string.
In MariaDB, RTRIM_ORACLE() is a synonym for the Oracle mode version of the RTRIM() function.
RTRIM_ORACLE() is available in all modes, so it saves you from having to switch to Oracle mode, which is what you’d need to do if you wanted the RTRIM() function to behave like Oracle’s RTRIM() function.
The difference is in how each function treats empty strings. Oracle returns null whereas MariaDB returns an empty string.
In MariaDB, EXTRACTVALUE() is a built-in string function that returns CDATA from an XML fragment.
The way it works is that it accepts two string arguments: a fragment of XML markup and an XPath expression (i.e. a locator). EXTRACTVALUE() then returns the CDATA (i.e. the text) of the first text node which is a child of the element or elements matching the XPath expression.
In MariaDB, TRIM() is a built-in string function that removes characters from the start or end of a string.
By default it removes leading and trailing spaces, but you can specify which character to remove, as well as which side/s you’d like it removed from.
Continue readingIn MariaDB, RTRIM() is a built-in string function that returns a string with any trailing space characters removed.
In MariaDB, LTRIM() is a built-in string function that returns a string with any leading space characters removed.
In MariaDB, the LOAD_FILE() function reads a file and returns the file contents as a string.
In MariaDB, RPAD() is a built-in string function that pads the right part of a string with a certain number of a specified character.
For example, you can use RPAD() to pad the right part of a string with dots.
In MariaDB, LPAD() is a built-in string function that pads the left part of a string with a certain number of characters.
For example, you can use LPAD() to pad the left part of a string with spaces. Or you could pad a number with leading zeros.