Formatting of SQL output
Hello All,
As part of capacity planning we are trying to analyze tablespace usage details based on AWR tables. I have a problem in formatting the output which makes everyone simple to understand on the difference. Using following SQL for details and it shows output like -
| DAYS | TSNAME | CUR_SIZE_MB USEDSIZE_MB |
---------- ------------ ----------- -----------
| 07-03-2014 TOOLS | 1600.00 | .13 |
| 08-03-2014 TOOLS | 1600.00 | .13 |
| 09-03-2014 TOOLS | 1600.00 | .13 |
| 10-03-2014 TOOLS | 1600.00 | .13 |
| 11-03-2014 TOOLS | 1600.00 | .13 |
| 12-03-2014 TOOLS | 1600.00 | .13 |
| 13-03-2014 TOOLS | 1600.00 | .13 |
| 14-03-2014 TOOLS | 1600.00 | .13 |
| 15-03-2014 TOOLS | 1600.00 | .13 |
| 07-03-2014 UNDO | 40004.00 | 16271.44 |
| 08-03-2014 UNDO | 40004.00 | 16279.44 |
| 09-03-2014 UNDO | 40004.00 | 16151.44 |
| 10-03-2014 UNDO | 40004.00 | 16215.44 |
| 11-03-2014 UNDO | 40004.00 | 16303.44 |
| 12-03-2014 UNDO |
0