How to remove string in oracle

Method: 1. Use the "TRIM([[STRING1] FROM] STRING2)" statement to remove the string; 2. Use the "LTRIM(STRING2,[STRING1])" statement to remove the string; 3. Use " RTRIM(STRING2,[STRING1])" statement to remove the string.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to remove a string in oracle

1. TRIM

Function: Remove the specified character at the specified position.

TRIM([LEADING|TRAILING|BOTH [STRING1] FROM] STRING2)

TRIM(STRING2)

Remove the spaces before and after the string STRING2.

SELECT TRIM('   左右两边空格   ') AS AA FROM DUAL;

TRIM([LEADING|TRAILING|BOTH STRING1 FROM] STRING2)

Remove string STRING2 remove the front|back|front and back (LEADING | TRAILING | BOTH ) character STRING1.

Note: STRING1 is one character and can be omitted (if omitted, spaces will be removed by default)

LEADING: Remove the character STRING1 in front (left) of STRING2.

SELECT TRIM(LEADING 'a' FROM 'aaasssdddsssaaa') AA FROM DUAL;

TRAILING: Remove the characters behind (right) STRING2 STRING1

##BOTH: Remove the characters before and after STRING2 STRING1.

When STRING1 is not entered, spaces (not other characters, such as \t, \n, etc.) are removed

2. LTRIM

Function: Remove the specified characters on the left side of the data.

Note:

1. You can enter a string and all characters contained in the string will be removed until it encounters a character that is not included.

2. If there are repeated characters in the input string, they will be counted as one.

3. The order of characters in the specified string is meaningless. When removing characters, it will only be judged whether the characters are in the specified string.

LTRIM(STRING2,[STRING1])

When STRING1 is not entered, remove the spaces to the left of STRING2.

SELECT LTRIM('   左边空格   ') AS AA FROM DUAL;

When inputting STRING1, remove the STRING1 characters from the first character on the left of STRING2 until the character is not STRING1. If the first character is not STRING1, directly Return STRING2.

SELECT LTRIM('aaasssdddsssaaa','as') AA FROM DUAL;

Note: If STRING1 and SHRING2 are reversed, and all characters in STRING1 appear in SHRING2, there will be no value

SELECT LTRIM('as','aaasssdddsssaaa') AA FROM DUAL;

3.RTRIM

Function: Remove the specified characters on the right side of the data.

Note:

1. You can enter a string and all characters contained in the string will be removed until it encounters a character that is not included.

2. If there are repeated characters in the input string, they will be counted as one.

3. The order of characters in the specified string is meaningless. When removing characters, it will only be judged whether the characters are in the specified string.

RTRIM(STRING2,[STRING1])

When STRING1 is not entered, remove the spaces to the left of STRING2.

SELECT RTRIM('   右边空格   ') AS AA FROM DUAL;

When inputting STRING1, remove the STRING1 characters from the first character on the left of STRING2 until the character is not STRING1. If the first character is not STRING1, directly Return STRING2.

SELECT RTRIM('aaasssdddsssaaa','as') AA FROM DUAL;

Recommended tutorial: "

Oracle Tutorial"

The above is the detailed content of How to remove string in oracle. For more information, please follow other related articles on the PHP Chinese website!