In an Oracle database, trim is generally used to delete spaces on both sides of a string. In fact, trim can also be used to delete specified characters on both sides of a string. And trim specifies that the deleted string can only be a single
LTRIM, RTrim, and trim usage in Oracle:1, LTRIM (C1,C2)where C1 and C2 can be strings, for example C1 is ' Miss Liu ', C2 ' MISL ' and so on. This is the first place that is not the same as SQL Server. If you remember good, SQL Server's LTrim has
1. Take a look at the complete syntax description of the Oracle Trim functionTRIM ([{{leading | TRAILING | BOTH}[Trim_character]| Trim_character}From]Trim_source)The above syntax is quoted from Oracle 10GR2 official documentation:
Php trim space trim is not implemented using str_replace. Php has a trime function for removing spaces. it can remove two spaces or directly use the ltrim function. the result of the rtrim function is the same as that of the trim function. if you
Definition and usage The trim () function removes spaces and other predefined characters from both ends of the string.
Syntax Trim (string, charlist) parameter description
String is required. Specifies the string to be checked.
Charlist is
Php learns to delete string whitespace characters. You can use Trim (), LTrim (), RTrim () functions to remove whitespace from the string masthead or end: $trimmed = Trim (String[,charlist]), $trimmed = LTrim (String[,charlist]); trimmed = RTrim
I read the Oracle document today and found that trim function usage is not limited to removing spaces of strings! Read the official explanation and the following experiment. I hope you can learn it together!
1. first look at the trim function syntax
Php has a trime function for removing spaces. It can remove two spaces or directly use the ltrim function. The result of the rtrim function is the same as that of the trim function. If you want to delete all spaces, you only need to replace
use of Trim (), TrimStart (), TrimEnd () in C #:These three methods are used to remove some characters from the tail of a string. Trim () removes whitespace from the head and tail of the string, removing the process from the outside to the inside
String Trim (String $str [, String $charlist = "\t\n\r\0\x0b"])This function returns the result of the string str after removing the trailing whitespace characters. If you do not specify a second parameter, trim () will remove these characters:1. ""
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.