SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to remove decimal point

user10243788Jul 13 2010 — edited Jan 18 2013

Hi all,

I have a table A, in which there is a column currency with integer values having decimal point, i have to just remove the decimal and keep the number as it is.

Ex:- A number 23.45 should be 2345
A number 17.9 should be 179

I have to do this for all the currency values of the table A.

Can someone kindly help me with a query.

regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2013

Added on Jul 13 2010

8 comments

34,562 views