SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to put SPACE thousands separator

862514Jun 18 2011 — edited Jun 18 2011

Hi there, I'm thinking how to format following numbers, eg: (integers)

150000
2000000

and I would like to export them as CSV file from sqldeveloper to MS Excel and displaying them like =>
(with space separator)

150 000
2 000 000

without Excel (formatting), so since beginning, Excel will see it as number with space thousands separaors

Could You help me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2011

Added on Jun 18 2011

5 comments

10,483 views