17,382
社区成员




select regexp_replace('01', '^0', '') from dual;
select regexp_replace('01234', '^0', '') from dual;
select regexp_replace('1234', '^0', '') from dual;
--如果有小數
select to_number(regexp_substr('A01.3','[0-9]+[.]?[0-9]*')) from dual;
/*
1.3
*/
select to_number(regexp_substr('A01','[0-9]+')) from dual;
/*
1
*/