CODEWITHSUNDEEP
oracle-database
surya Narayana
surya Narayana

Reputation: 1

Need to display decimal values in oracle

I need to display the 3 decimal values if the number having decimal value, for suppose the number does not having decimal then will display zero's after decimal I tried with TO_CHAR function but when i am converting to_char into TO_NUMBER it's displaying number with rounded values

Upvotes: 0

Views: 2809

Answers (2)

djadmin
djadmin

Reputation: 1760

If you have privileged to change the SCHEMA, then you can do it this way:

ALTER TABLE TABLENAME Modify Attrib Number(10,3);

Upvotes: 0

Erich Kitzmueller
Erich Kitzmueller

Reputation: 36987

Your question is a bit vague, but I guess you need something like

TO_CHAR(n, '999G990D000')

to show the zeros.

Upvotes: 1

Related Questions