SQL> SELECT * from AA;
BB CC ---------- ---------- 1 999999.99
SQL> Col Bb Format '9999; SQL> SELECT * AA;
BB CC -------------- 1.0 999999.99
SQL> Col Bb Head '9999; SQL> SELECT * AA;
99.9 CC -------------- 1.0 999999.99
SQL> Col Bb Head 'Learn'; SQL> SELECT * AA;
Learn cc -------------- 1.0 999999.99
SQL> Col Bb Format '99'; SQL> SELECT * from AA;
Learn cc ---- ---------- 1 999999.99
SQL> COL BB Head 'Learn | SQL> SELECT * from AA;
Journal CC -------------- 1 999999.99
SQL> SELECT Count (BB), SUM (CC) from AA;
Count (bb) SUM (CC) ---------- ---------- 8192 8191999918
SQL> Col sum (CC) Format '9999999999.99; SQL> SELECT COUNT (BB), SUM (CC) from AA;
Count (bb) SUM (CC) ---------- -------------- 8192 8191999918.08
SQL> COL SUM (CC) Format '999999999.99' Head 'Total'; SQL> Col County (BB) Format '999999' Head '; SQL> SELECT COUNT (BB), SUM (CC) from AA;
Total number of people -------------------- 8192 8191999918.08
