Oracle Forms (MOSC)

MOSC Banner

Dont want to Round amount

edited Feb 23, 2012 11:18PM in Oracle Forms (MOSC) 7 commentsAnswered
Hi,

I have amount as 1348,25 and want to show it as 134825.

For this I used

trim(to_char(REPLACE(unit_selling_price * 100,'.',''),'999999999999')) price

but it returns

1348

as it rounds it.

Is there a way it dont round the result?

Thanks,

/ZAB

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center