Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to send a fixed-format mail from unix
I've had the same problem before and changing to fixed-width font alone didn't fix it - I had to use the expand command to replace tabs with spaces AND use a fixed-width font.
Here is an example when I send the email with fixed-width, but no expand command:
DATABASE SID USERNAME OSUSER TYPE OBJECT_NAME LMODE SECONDS BLOCK
--------- ---------- ------------ ------------ ---- ------------------------- ---------- ---------- ---------- D517 36 LREIMERS Lreimers TX 6 916 0 D517 36 LREIMERS Lreimers TM CT_ADDR_CODE 2 916 0
And, here is an example sent with *with* the expand command:
DATABASE SID USERNAME OSUSER TYPE OBJECT_NAME LMODE SECONDS BLOCK --------- ---------- ------------ ------------ ---- ------------------------- ---------- ---------- ---------- D500 36 LLEMPERT llempert TX 6 12 0 D500 36 LLEMPERT llempert TM FRL_PERIOD_BAL 3 12 0
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of bill thater
Sent: Friday, July 29, 2005 4:45 AM
To: sharmakdeep_oracle_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: how to send a fixed-format mail from unix
On 7/28/05, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
> I am trying to send the output of a sqlplus script
> from Unix (using mailx) to Lotus Notes addresses.
>
> The output looks formatted on Unix, but when opened in
> Lotus Notes, the formatting is no longer there.
>
> Any Tips?
get them to set the display in Notes to fixed format.;-)
this is a client issue and not a server issue, by default Notes [and Outlook and some others] display received email in flexable spaced fonts. changing the display to use a fixed font will solve the problem.
-- -- Bill "Shrek" Thater ORACLE DBA shrekdba_at_gmail.com ------------------------------------------------------------------------ "Zen is not easy. It takes effort to attain nothingness. And then what do you have? Bupkes." -- The Goddess -- http://www.freelists.org/webpage/oracle-l Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 29 2005 - 11:04:22 CDT
![]() |
![]() |