日期:2014-05-17 浏览次数:20937 次
select regexp_substr('2011-7-6 1','[^[:space:]]*') from dual;
------解决方案--------------------
select regexp_replace('2011-7-6 1','[[:space:]]+.*') from dual; select regexp_replace('2011-11-16 1','[[:space:]]+.*') from dual;