急，怎么把数据转换为number(8,2)，select to_number('2.10') from dual;

Question

急，怎么把数据转换为number(8,2)，select to_number('2.10') from dual;

Answer 1

SQL> select to_char('2.100','99999.99') from dual;TO_CHAR('
---------
     2.10
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   TABLE ACCESS (FULL) OF 'DUAL'
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

Answer 2

什么意思，'2.10'转成number(8,2)是什么样子