Change numeric format in Data Grid

Toad for Oracle & DevOps Toolkit
1

In Toad 14 I have tried to change the numeric character:

alter session set NLS_NUMERIC_CHARACTERS = ',.';

When I execute this SQL

select 1/2 from dual;

The result is get is

0.5

How do get it to display as

0,5

2

image
image1064×762 50.6 KB

1 Like
3

Hello,

I have Toad 16.1.53.1594 and cannot change this Numeric parameters in Toad Options.
I change it (Decimal: "," and Thousand: ".") and apply, but then I try:
select 1/2 from dual;
It's 0.5

When i open again Toad Option, boxes in Numeric characters are empty:

Capture

I also found this option in Toad.ini file:

FindDialogMRU=NLS_LANG,NLS,Info,".,",

But when I change it in this file (".," to ",.") something changes automatically this back to ".," (?)
Can someone help me?

4

Hello,

That entry in Toad.ini is not related to this.

This is a bug in 16.1. To set the Decimal and thousands in 16.1, follow these steps:

  1. open the options window.
  2. along the left, go to Data Grids -> Data
  3. along the left, go to General
  4. now the decimal/thousands values are not blank and you can set them.

This is fixed in 16.2.

5

Interesting solution for bug. :slight_smile:
Thank you very much, it works