Number of decimal digits in Oracle SQL Developer query result sheet

1
votes

The Date format can be customized in Oracle SQL Developer, how Decimal format can be specified? By that I mean number of decimal digits.

In Tools>Preferences>Database>NLS we only have decimal separator, nothing else. Thank you in advance.

1
oraclenumbersdecimaloracle-sqldeveloper

1 Answers

3
votes

There is no option in Preferences to my knowledge. You can use to_char function to display the decimal digits.

An example:

Try this in HR schema:

select to_char(salary,'999999.000'), employee_id from employees;