 
MariaDB TRIM_ORACLE SQL Function - Remove spaces or characters |
|
| | TRIM_ORACLE | Syntax: | TRIM_ORACLE([[Type] [Delete character] FROM] String) | | Return value: | CHAR | | Function type: | String function | |
| | The TRIM_ORACLE() function removes spaces or a defined "Delete character" from the beginning and/or end of a "String".
The optional parameter "Type" can have the following values: BOTH, LEADING or TRAILING.
If "Type" is not specified, BOTH is the default and the "Delete character" or spaces are removed from the beginning and the end of the "String".
If "Delete character" is not specified, spaces will be removed.
If the value of "String" is NULL, the TRIM_ORACLE() function returns NULL.
Unlike TRIM, TRIM_ORACLE() returns NULL if the result is an empty string.
The feature is available from MariaDB version 10.3.6. This feature is not present in MySQL 8.0. | SQL Examples for the TRIM_ORACLE function |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
| select trim_oracle(' Test ');
select trim_oracle(LEADING from ' Test ');
select trim_oracle(TRAILING from ' Test ');
select trim_oracle(BOTH from ' Test ');
select trim_oracle(LEADING 'x' from 'xxxTestxxx');
select trim_oracle(TRAILING 'x' from 'xxxTestxxx');
select trim_oracle(BOTH 'x' from 'xxxTestxxx');
select trim_oracle(BOTH 'x' from 'xxxxxx');
SELECT TRIM(''),TRIM_ORACLE('');
select trim_oracle(null);
|
|
| trim_oracle(' Test ') |
|---|
| varchar(11) BINARY |
|---|
| Test |
|
|
| trim_oracle(LEADING from ' Test ') |
|---|
| varchar(11) BINARY |
|---|
| Test |
|
|
| trim_oracle(TRAILING from ' Test ') |
|---|
| varchar(11) BINARY |
|---|
| Test |
|
|
| trim_oracle(BOTH from ' Test ') |
|---|
| varchar(11) BINARY |
|---|
| Test |
|
|
| trim_oracle(LEADING 'x' from 'xxxTestxxx') |
|---|
| varchar(10) BINARY |
|---|
| Testxxx |
|
|
| trim_oracle(TRAILING 'x' from 'xxxTestxxx') |
|---|
| varchar(10) BINARY |
|---|
| xxxTest |
|
|
| trim_oracle(BOTH 'x' from 'xxxTestxxx') |
|---|
| varchar(10) BINARY |
|---|
| Test |
|
|
| trim_oracle(BOTH 'x' from 'xxxxxx') |
|---|
| varchar(6) BINARY |
|---|
| NULL |
|
|
| TRIM('') |  |
| TRIM_ORACLE('') |
|---|
| varchar(0) BINARY | varchar(0) BINARY |
|---|
| NULL |
|
|
|
|
| trim_oracle(null) |
|---|
| varchar(0) BINARY |
|---|
| NULL |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the TRIM_ORACLE() function in MariaDB databases | | In MariaDB the TRIM_ORACLE() function is used to remove leading and trailing spaces, or other specified characters, from a string. This allows strings to be cleaned up by removing unnecessary spaces or specific characters at the beginning and end. The TRIM_ORACLE() function is often used to clean data, normalize input, or remove unnecessary characters before performing comparisons or storing data. Unlike the TRIM() function, TRIM_ORACLE() returns NULL if the inheritance is empty. | | Further MySQL und MariaDB SQL String functions | | CHAR | CHAR(Character code, [, Charset]) | | More about CHAR Function |
| | CHR | CHR(Character code) | | More about CHR Function |
| | CONCAT | CONCAT(Strings ('str1','str2', ...)) | | More about CONCAT Function |
| | CONCAT_WS | CONCAT_WS(Separator, Strings ('str1','str2', ...)) | | More about CONCAT_WS Function |
| | ELT | ELT(Index, Strings ('str1','str2', ...)) | | More about ELT Function |
| | EXPORT_SET | EXPORT_SET(Bits, On, Off [, Separator] [, Number of bits]) | | More about EXPORT_SET Function |
| | EXTRACTVALUE | EXTRACTVALUE(XML, XPath) |
| | FIELD | FIELD(Search string, Strings ('str1','str2', ...)) | | More about FIELD Function |
| | FORMAT | FORMAT(Number, Decimals [, Region]) | | More about FORMAT Function |
| | INSERT | INSERT(String, Position, Length, String to insert) | | More about INSERT Function |
| | LCASE | LCASE(String) | | More about LCASE Function |
| | LEFT | LEFT(String, Length) | | More about LEFT Function |
| | LOAD_FILE | LOAD_FILE(File name) |
| | LOWER | LOWER(String) | | More about LOWER Function |
| | LPAD | LPAD(String, Length, String to append) | | More about LPAD Function |
| | LPAD_ORACLE | LPAD_ORACLE(String, Length, String to append) | | More about LPAD_ORACLE Function |
| | LTRIM | LTRIM(String) | | More about LTRIM Function |
| | MAKE_SET | MAKE_SET(Bits, Strings ('str1','str2', ...)) | | More about MAKE_SET Function |
| | MID | MID(String, Position [, Length]) | | More about MID Function |
| | QUOTE | QUOTE(String) | | More about QUOTE Function |
| | REPEAT | REPEAT(String, Number) | | More about REPEAT Function |
| | REPLACE | REPLACE(String, Search, Replace) | | More about REPLACE Function |
| | REVERSE | REVERSE(String) | | More about REVERSE Function |
| | RIGHT | RIGHT(String, Length) | | More about RIGHT Function |
| | RPAD | RPAD(String, Length, String to append) | | More about RPAD Function |
| | RPAD_ORACLE | RPAD_ORACLE(String, Length, String to append) | | More about RPAD_ORACLE Function |
| | RTRIM | RTRIM(String) | | More about RTRIM Function |
| | SOUNDEX | SOUNDEX(String) | | More about SOUNDEX Function |
| | SPACE | SPACE(Number) | | More about SPACE Function |
| | SUBSTR | SUBSTR(String, Position, Length) | | More about SUBSTR Function |
| | SUBSTRING | SUBSTRING(String, Position, Length) | | More about SUBSTRING Function |
| | SUBSTRING_INDEX | SUBSTRING_INDEX(String, Delimiter, Number) | | More about SUBSTRING_INDEX Function |
| | TRIM | TRIM([Type] [, Delete character], , String) | | More about TRIM Function |
| | UCASE | UCASE(String) | | More about UCASE Function |
| | UPPER | UPPER(String) | | More about UPPER Function |
| | WEIGHT_STRING | WEIGHT_STRING(String [AS Format] [LEVEL Level] [Sorting]) | | More about WEIGHT_STRING Function |
| | ASCII | ASCII(String) | | More about ASCII Function |
| | BIT_LENGTH | BIT_LENGTH(String) | | More about BIT_LENGTH Function |
| | CHAR_LENGTH | CHAR_LENGTH(String) | | More about CHAR_LENGTH Function |
| | CHARACTER_LENGTH | CHARACTER_LENGTH(String) | | More about CHARACTER_LENGTH Function |
| | FIND_IN_SET | FIND_IN_SET(Search string, Set of values) | | More about FIND_IN_SET Function |
| | INSTR | INSTR(String, Search string) | | More about INSTR Function |
| | LENGTH | LENGTH(String) | | More about LENGTH Function |
| | LENGTHB | LENGTHB(String) | | More about LENGTHB Function |
| | LOCATE | LOCATE(Search string, String [, Position]) | | More about LOCATE Function |
| | OCTET_LENGTH | OCTET_LENGTH(String) | | More about OCTET_LENGTH Function |
| | ORD | ORD(String) | | More about ORD Function |
| | POSITION | POSITION(Search string IN String) | | More about POSITION Function |
|
|
| | | More information about the TRIM_ORACLE SQL function: |
|
|
|
|
