Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Enforce 2 decimal places after a column result in s query. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Enforce 2 decimal places after a column result in s query.

Received Response
12
Views
4
Comments

Summary:

The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 45.60 etc.

we need it to happen in SQL query.

Content (required):

There is a table column that can have number values like 2,3 ,400,45.78,34,28 ,4.00 etc. Is there a way in SQL to stipulate it to always have 2 places after decimal like 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 45.60 etc.


This is a system table & hence no table level constraints are possible.


Any idea would be appreciated.


Thanks,


Aloka

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!