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!

Need SQL Query to give output in decimal only when decimal is existed in value

SravpremJun 20 2023

I'm looking for a query to display decimals only when decimals are present in column values. If it is not a decimal number, it should print normally.

ex :- if the column value is 5000, then my query output should be 5,000

      If the column value is 1500.02 then my query output should be 1,500.02

Could you please help me with this?

Thanks,

This post has been answered by mathguy on Jun 20 2023

Jump to Answer

Added on Jun 20 2023

2 comments

572 views