Oracle PLSQL Report Column Page 18 codes

1 Add dollar signs to the output

2 Change column heading format

3 Change line size twice

4 Clear the column format

5 COLUMN FORMAT

6 COLUMN Number FORMAT

7 If the column format is too small

8 Number format cannot be too short

9 PAGESIZE option controls how many lines appear on a page

10 Set line width to 300 characters

11 Set number format to $9,999 99

12 Set pagesize

13 Show and set the linesize

14 The COLSEP option affects the character displayed between columns

15 The HEADING option enables you to control whether the column headers are displayed

16 To avoid having naked decimal points

17 Use column command to change the column heading

18 Use column command to set word_wrapped for column data display