Oracle里去掉字符串空格
- WBOYOriginal
- 2016-06-07 17:45:411208browse
Oracle里去掉字符串空格
去除两侧空间
SQL> select trim(' 123 ') from dual;
TRI
---
123
SQL>
Oracle里去掉右侧字符串空格(RTRIM)
select rtrim(' 123 ') from dual;
SQL> select ltrim(' 123 ') from dual;
LTRI
----
123
SQL>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：merge into合并资料Next article：Oracle数据库和JSP连接注意细节