Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Text format while emailing

793661Aug 25 2010 — edited Aug 25 2010
Hello All,

We are trying to generate a report from the server using simple shell script and SQL commands. The spool file is in a proper readable format but, when it comes to our email box the text is all cluttered. Tried a lot but dint seem to get anywhere....

Sample output below:

********Actual size of the data in segments which have > 5000 extents************
PREM_DIM 30.67 26.41 4.26
PREM_HIST_TMP 1.68 1.35 .32
SERV_ORD_HIST 57.15 46.04 11.11
SERV_ORD_HIST_F 53.34 44.41 8.93
TEN_HIST 32.54 25.51 7.03
TEN_HIST_TMP 3.86 3.04 .82
WO_EVNT 34.84 27.25 7.59
WO_EVNT_HIST 32.52 24.99 7.53
WRK_ORD 46.03 35.09 10.94
WRK_ORD_HIST 111.82 79.82 32




Is there anyone who can help me on this please? Appreciate it.

Thanks,
K
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2010
Added on Aug 25 2010
4 comments
827 views