SET NUMFORMAT

Syntax

SET NUMFORMAT <Formatstring>;

Description

Sets the formatting of numeric columns in tables. The format string is the same as that of the COLUMN statement. There you also can find a more complete description of the possible formats. This setting is only used for numeric columns that have not had a different format defined with the COLUMN statement.

Examples

SQL_EXA> set numformat 99990.00;
SQL_EXA> select 43 from dual;