+--------------------+
1 row in set
示例3:expr 为“+000000123”。
gbase> SELECT TO_NUMBER('+000000123') FROM dual;
+-------------------------+
| TO_NUMBER('+000000123') |
+-------------------------+
|
123 |
+-------------------------+
1 row in set
示例4:expr 为“1234”。
gbase> SELECT TO_NUMBER('1234') FROM dual;
+-------------------+
| TO_NUMBER('1234') |
+-------------------+
|
1234 |
+-------------------+
1 row in set