Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    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.

    Thanks.
    Jerry

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you may want to ask this question in the oracle forum

    mysql can do it, but mysql cannot run SQL*Plus
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •