CODEWITHSUNDEEP
oracle11g
Sandoval0992
Sandoval0992

Reputation: 1367

Is it possible to round an integer number to thousands in Oracle?

For example, if I have the number 7900 then I wanna get the number 8000 as a result.

Upvotes: 0

Views: 1013

Answers (1)

Sascha A.
Sascha A.

Reputation: 4616

I don't know much from Oracle, but have a look at https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htm There you can see, that you can round a DUAL to ten's with

    SELECT ROUND(15.193,-1) "Round" FROM DUAL;

     Round
----------
        20

So I suppose that you can do this with a -3 and integer in the way you want it.

Upvotes: 3

Related Questions