Data Format
NLS Format
NLS Format can be changed. Changing the NLS format is only available by unchecking the Skip NLS Setting option. At this time, a reconnection notification modal appears, and if the users click the [Confirm] button, all connected sessions except the session that is running to apply NLS Format will be reconnected.
The description of each item is as follows.
NLS Date Format
Sets the NLS Date format. (NLS_DATE_FORMAT) The default is YYYY/MM/DD.
NLS Timestamp Format
Sets the NLS Timestamp format. (NLS_TIMESTAMP_FORMAT) The default is YYYY/MM/DD HH24:MI:SSXFF.
NLS Time Format
Sets the NLS Time format. (NLS_TIME_FORMAT) The default is HH24:MI:SSXFF.
0 Truncate
Omits 0 if NLS Timestamp ends 0. The default is False.
Skip NLS Setting
Does not apply NLS setting. The default is True.
Number Format
Specifies the display format for numbers in the data in the Result Table. Each item is described below.
Decimal places
Sets the number of decimal places. The default is 37.
Use 1000 Separator (,)
Displays commas (,) in 1000 units. The default is False.
Negative numbers
Sets the display format for negative numbers.
Last updated