Monday 21 February 2011

Round the number and always show decimal places...

The following is the way to round the number and always show two decimal places:

SELECT to_char(round(678,2), '9999999.99') FROM dual;

No comments:

Post a Comment

Azure OpenAI Architecture Patterns & Deployment Patterns

Sharing some useful links that will help customers architect Azure OpenAI solution using the best practices: (1) Azure OpenAI Landing Zone r...