var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Drop Trailing Zero in Decimal from Select
I am new to SQL and would like to know if numeric values like $25.30 can be displayed from a SELECT statement as $25.3, or $50.00 would be displayed as $50
I've looked at COLUMN column_name FORMAT and have not found a code, if there is one, to not display trailing zeros in a decimal.
Yes! This is SQL *Plus version 9.2 homework and I am searching for the answer.
you may want to ask this question in the oracle forum
mysql can do it, but mysql cannot run SQL*Plus