Skip to Main Content

oracle sql output for outlook email body

4d475ca6-d057-4177-9e38-6e94e7006b06Feb 24 2017 — edited Feb 24 2017

HI to All,

I need to add output query into an email auto reporting body. Fut the sql script formatting output is misaligned.

on considering the below-set formatting:

set pages 5000

set feed off

spool on

set colsep "|"

set lines 256

set trimout on

set trimspool on

set feedback off;

set lines 256

COLUMN SET_NAME FORMAT A40

via sqlDeveloper runScript command I get the below output: (in the below output SE, REPORT_TIME columns was removed but the misalignment persist.)

xxx.png

but into email body report I get the below output:

yyy.png

Could you suggest a smart way for make compatible the Standard Oracle sql script output format with Microsoft Outlook body email format? ( on focus with MO 2016 version)

I'm available for dubs or questions,

thanks a lot,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Mar 24 2017
Added on Feb 24 2017
4 comments
786 views