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.

Thanks.
Jerry

you may want to ask this question in the oracle forum

mysql can do it, but mysql cannot run SQL*Plus