CODEWITHSUNDEEP
oracle-databasenumbersdecimaloracle-sqldeveloper
mostafa.S
mostafa.S

Reputation: 1584

Number of decimal digits in Oracle SQL Developer query result sheet

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.

Upvotes: 1

Views: 19199

Answers (1)

vijayaragavan
vijayaragavan

Reputation: 176

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;

Upvotes: 3

Related Questions