Re: SQLPlus formatting question

From: <sybrandb_at_yahoo.com>
Date: 10 Jun 2005 06:13:45 -0700
Message-ID: <1118409225.479462.254380_at_g14g2000cwa.googlegroups.com>

to_char(...,'fm0999')
will use suppress the space in front of a positive number.

This is also not a SQL*Plus issue but a SQL issue. Refer to the SQL reference manual for all available to_char format models.

--
Sybrand Bakker
Senior Oracle DBA

Received on Fri Jun 10 2005 - 15:13:45 CEST

This message: [ Message body ]
Next message: Chris F: "Re: Help on Multiselect LOVs in Oracle forms"
Previous message: aldark_at_eircom.net: "SQLPlus formatting question"
In reply to: aldark_at_eircom.net: "SQLPlus formatting question"
Next in thread: aldark_at_eircom.net: "Re: SQLPlus formatting question"
Reply: aldark_at_eircom.net: "Re: SQLPlus formatting question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message