Someone know oracle decimal fraction conversion?

Asked By matland maud 10 points N/A Posted on - 08/25/2012

Hi Experts,

I am having oracle on my laptop.I need to know about oracle decimal fraction conversion.Any database expert advice me.I tried some commands but I am not expert in database area.Thanks.

Regards,

Matland Maut

• Status: Open
• Question Views: 1121
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB2

Answered By Carl Jack 10 points N/A #133633

Someone know oracle decimal fraction conversion?

Hello Matland,

You can for sure be able to decimal numbers to fractions in oracle. The following is an SQL code that will help you will that process:

SQL> create or replace

  2  function formula_to_number(p_formula in varchar2) return number as

  3     l_formula varchar2(30);

  4     l_result  number;

  5  begin

  6     l_formula := replace(p_formula,' ','+');

  7     execute immediate 'select ' || l_formula || ' from dual' into l_result;

  8     return l_result;

  9  end;

10  / 

Function created.

SQL> select formula_to_number('2 3/4') from dual;

FORMULA_TO_NUMBER('23/4')

-------------------------

                     2.75

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/25/2012
• Question Category: DB2