Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle里去掉字符串空格

Oracle里去掉字符串空格

WBOY
Release： 2016-06-07 17:45:41
Original
1344 people have browsed it

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>

Related labels：
from select sql
source：php.cn
Previous article：merge into合并资料 Next article：Oracle数据库和JSP连接注意细节
Statement of this Website
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
Latest Articles by Author
Latest Issues
json added to MySQL How to add new element to json variable in mySQL from this: value=['123'] do this: value=[...
From 2024-04-04 19:17:30
0
1
352
Regular expression to replace several symbols with HTML tags I'm trying to build a regular expression that replaces all symbols "$$" with som...
From 2024-04-01 21:01:01
0
2
358
How to increase the number entered? I'm trying to implement the step attribute when using the HTMLinput element. This way I ca...
From 2024-04-01 19:13:50
0
2
267
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template