Column Number Format « Report Column Page « Oracle PL / SQL






1.Add dollar signs to the output
2.COLUMN Number FORMAT: 999,999
3.COLUMN Number FORMAT: 999
4.If the column format is too small
5.To avoid having 'naked' decimal points
6.Set number format to '$9,999.99'
7.Number format cannot be too short