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!

Convert To_Number without Decimals

Johnbr (Oracle10G)Sep 10 2012 — edited Sep 10 2012

Hi,

I have a value that I need in the number format, but without decimals. Is this possible?

TO_NUMBER(SY_KEY1,'9999999') AS SY_KEY1

The result I get back is:

1114225.0

So, I need a result of 1114225 and in the number format.

Thanks :)

John

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2012

Added on Sep 10 2012

2 comments

4,384 views