17,140
社区成员




select substr(to_char(12345678.12),
1,
(select case
when instr(to_char(12345678.12), '.') - 1 <= 7 then
instr(to_char(12345678.12), '.') - 1
else
7
end
from dual)) ||
substr(to_char(12345678.12), instr(to_char(12345678.12), '.'), 3)
from dual;