Hi,
I am new to Sqlplus in Oracle.
Is there any method to remove the blank space in SQL?
I know set heading off will actually remove the header. But what about to remove those spaces?
2011-JUN-05 | 01:05 | 749.7867 | .14
2011-JUN-05 | 01:10 | 726.11 | .1133
2011-JUN-05 | 01:15 | 679.9033 | .06
2011-JUN-05 | 01:20 | 694.7933 | .0667
2011-JUN-05 | 01:25 | 657.0367 | .0533
2011-JUN-05 | 01:30 | 664.54 | .08
2011-JUN-05 | 01:35 | 613.4433 | .0533
2011-JUN-05 | 01:40 | 602.6133 | .0633
2011-JUN-05 | 01:45 | 596.1833 | .02
2011-JUN-05 | 01:50 | 581.5367 | .1633
2011-JUN-05 | 01:55 | 554.77 | .2433
2011-JUN-05 | 02:00 | 550.14 | .0267
2011-JUN-05 | 02:05 | 519.19 | .0267
2011-JUN-05 | 02:10 | 506.17 | .0567
2011-JUN-05 | 02:15 | 492.4067 | .0333
2011-JUN-05 | 02:20 | 472.9567 | .0433
2011-JUN-05 | 02:25 | 449.16 | .0267
2011-JUN-05 | 02:30 | 414.2733 | .1033
2011-JUN-05 | 02:35 | 441.6 | .08
2011-JUN-05 | 02:40 | 414.8433 | .0267
2011-JUN-05 | 02:45 | 403.7067 | .0333
2011-JUN-05 | 02:50 | 404.6 | .02
Thanks.