Displaying number before decimal points in oracle

0 votes

1 answer

1653 views

                          I have a logic where I want to calculate and display numbers based upon some operations. The operations are below

V_CALPERCENT nvarhcar(100), v_yearMSA1 nvarchar(100), 

So I want to calculate V_CALPERCENT and I have one value for v_yearMSA1 = 2 

SO here goes my calculation,

    V_CALPERCENT :=  (v_yearMSA1  * 2.25) / 100

Its returning me as .05

where as I want it should also display the number before decimal point. How to get it please help

Asked by HEEN (203 rep)

Jan 12, 2021, 02:35 PM
Last activity: Jan 13, 2021, 07:44 PM

Displaying number before decimal points in oracle

Related Questions