Solved

# Oracle + plsql

Posted on 2009-03-30

I've a small doubt, if any body knows pls give me some solution.

In my oracle table i've 2 columns AMOUNT & DECIMAL. So based on the decimal value, i've to convert the amount as mentioned in the FINAL_RESULT colum.

Ex: For amount 10000 its decimal places are 2, so i've give final_result as 100.00

see the following data,

Amount Decimal Final_Result

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

10000 2 100.00

19388 3 19.388

344334 4 34.4334

Like that n no. of Amounts are there & n no. of decimal are there

How can i achieve the above Final_Result based on the Amount & Decimal columns.

Its very urgent......... reply pls. Give me the sol....