What are the Oracle functions for removing spaces?

Oracle's functions for removing spaces include: 1. LTRIM() function, which can delete the space characters on the left side of the parameter string; 2. RTRIM() function, which can delete the space characters on the right side of the parameter string; 3. , TRIM() function, which can delete space characters on the left and right sides of the parameter string at the same time.

The operating environment of this tutorial: Windows 7 system, Oracle 11g version, Dell G3 computer.

oracle function to remove spaces

##RTRIM(X[,TRIM_STR])Put the right side of X Truncate the trim_str string, and truncate spaces by default TRIM([TRIM_STR FROM]X)

##Function	Instructions
LTRIM(X[,TRIM_STR])	Truncate the left side of X trim_str String, spaces are truncated by default
Put both sides of X Trim the trim_str string, and truncate spaces by default

LTRIM() function

LTRIM() function can only delete parameters The space character on the left side of the string

RTRIM() function

RTRIM() function can only delete the right side of the parameter string The space characters

TRIM() function

TRIM() function can simultaneously delete the space characters on the left and right sides of the parameter string.

Recommended tutorial: "

Oracle Tutorial

"

The above is the detailed content of What are the Oracle functions for removing spaces?. For more information, please follow other related articles on the PHP Chinese website!