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
| ##Function | Instructions |
| LTRIM(X[,TRIM_STR]) | Truncate the left side of X trim_str String, spaces are truncated by default |
| Put the right side of X Truncate the trim_str string, and truncate spaces by default | |
| Put both sides of X Trim the trim_str string, and truncate spaces by default |
LTRIM() function can only delete parameters The space character on the left side of the string
RTRIM() function can only delete the right side of the parameter string The space characters
TRIM() function can simultaneously delete the space characters on the left and right sides of the parameter string.
Recommended 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!
