plsql 小数转分数 和 分数转小数

分数转小数在plsql里面可以直接转换的

即可用select 1/2 from dual;得到 0.5;

小数转换分数,我自己写了一个sql语句进行实现;

select decode(mod(a, b),
              0,
              to_char(a / b),
              to_char(a / ys) || '/' || to_char(b / ys)) as result,
       ys
  from (select a, b, max(le) as ys
          from (select a, b, level as le, mod(a, level) aa, mod(b, level) bb
                  from (select s * power(10,
                                         (length((to_char(s))) -
                                         instr(to_char(s), '.'))) as a,
                               power(10,
                                     (length((to_char(s))) -
                                     instr(to_char(s), '.'))) as b
                          from (select 5.123 as s from dual))
                connect by level <= a) t
         where aa = 0
           and bb = 0
         group by a, b)

但是这句sql有个毛病，就是 小数后面的数字不能太长，否则执行时间过长，效率低下；即5.123 换成5.1212121212121的话估计会死掉；呵呵

请哪位大侠指导指导~~~~~~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14313603/viewspace-374401/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14313603/viewspace-374401/