11:20:38 SQL> select length(100)-decode(instr(to_char(100),'.'),0,length(100),in
str(to_char(100),'.')) from dual;
LENGTH(100)-DECODE(INSTR(TO_CHAR(100),'.'),0,LENGTH(100),INSTR(TO_CHAR(100),'.')
)
--------------------------------------------------------------------------------
-
0
已用时间:00: 00: 00.15
11:20:55 SQL> select length(100.235)-decode(instr(to_char(100.235),'.'),0,length
(100.235),instr(to_char(100.235),'.')) from dual;
LENGTH(100.235)-DECODE(INSTR(TO_CHAR(100.235),'.'),0,LENGTH(100.235),INSTR(TO_CH
AR(100.235),'.'))
--------------------------------------------------------------------------------
-----------------
3
已用时间:00: 00: 00.00
11:21:12 SQL> select length(100.9)-decode(instr(to_char(100.9),'.'),0,length(100
.9),instr(to_char(100.9),'.')) from dual;
LENGTH(100.9)-DECODE(INSTR(TO_CHAR(100.9),'.'),0,LENGTH(100.9),INSTR(TO_CHAR(100
.9),'.'))
--------------------------------------------------------------------------------
---------
1
已用时间:00: 00: 00.00
|