【www.gdgbn.com--python】
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>
【www.gdgbn.com--python】
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>