Oracle will you really use the ltrim/rtrim function ?, Ltrimrtrim

Source: Internet
Author: User

Oracle will you really use the ltrim/rtrim function ?, Ltrimrtrim

The common usage is to remove spaces. How many people do not know that they can actually remove spaces? It has the ltrim () and ltrim (x, y) methods.

------- Remove spaces on both sides, left space, right space -------- select trim ('x-rapido ') name from dual; returns 'x-rapido 'select ltrim ('x-rapido') name from dual; returns 'x-rapido 'select rtrim ('x-rapido') name from dual; returns ''x-rapido ''select trim (null) name from dual; returns null.


Ltrim (x, y) syntax

The ltrim (x, y) function intercepts the characters in x one by one based on the characters in y, and runs them from the left. As long as some characters in y are met, the characters in x will be truncated, the Function Command ends only when y is not included in the x character.

Select ltrim ('abcababababe ',' AB ') word from dual;

Result: cdabababe

Select ltrim ('aaaaa', 'A') word from dual;

Result: null is null.

Select ltrim ('20140901', '20160901') nums from dual;

Result: 224323

Select ltrim ('20140901', '20160901') nums from dual;

Result: 4323

Select ltrim ('20140901', '20160901') nums from dual;

Result: 224323

Select ltrim ('20140901', '20160901') nums from dual;

Result: 200111000991110224323

Select ltrim ('20140901', '20160901') nums from dual;

Result: 2100111000991110224323


Note: Oracle is case sensitive.

Select ltrim ('abcdab', 'B') word from dual;

Result: abcdab


As for the rtrim function, like ltrim, one starts from the left and the other starts from the right.


The string truncation function is different from the substr function, because one is a specified character and the other is a specified subscript.


Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.