Is it possible to display large numbers with thousands separator in Toad's Data Grid? Numbers in the Data Grids do not appear to show separators.
Enter the following and execute each line separately with F9 or 'Execute as Statement' option:
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ".," ;
select TO_CHAR(<column name>, '999G999G999G999G999G999D99') from <table name>';
Note: The first parameter of NLS_NUMERIC_CHARACTERS (.) is the decimal separator and the second (,) is the thousands separator.
The Alter Session command can be added to the Login.sql file of Oracle Client to be automatically executed at the startup of session.
The Decimal Separator of Toad's Options control the Record Count option of the Data Grid.
