Sqlplus HTML Report

From: Reardon, Bruce (BBA) <"Reardon,>
Date: Tue, 21 Aug 2018 05:23:56 +0000
Message-ID: <318531857F7D1F4E877702B6B3A298A986A9C551_at_PABBYEX01.pa.local>

Hi Sanjay,
There may well be better ways, but what about doing UNION ALL with a select of 6 NULLs from dual? This will give you a blank row in your report, and you'd want to turn feedback off as the number of rows returned message would be misleading. Regards,
Bruce

---

Date: Tue, 21 Aug 2018 00:27:26 +0000 (UTC) From: "Sanjay Mishra" <dmarc-noreply_at_freelists.org> (Redacted sender Subject: Sqlplus HTML Report

Can someone help as what I am missing in the following report. Below SQL works and create report when there are some rows but comes out blank when there is no rows. I want to display the title atleast in blank as it is sent as email. Blank email confuse as what is the report

_at_htmlon

spool myreport3.htm

COLUMN name NEW_VALUE _instname NOPRINT

select upper(name) name from v$database;

Column Title Entmap off

set heading on

TTITLE CENTER '<h1>Daily Report : - Inactive User Session </h1>' -

RIGHT 'Page:' FORMAT 999 SQL.PNO

select username, sid,serial#,machine,program,logon_time

from v$session s

where username IS NOT NULL AND username NOT IN ('SYS','SYSTEM','DBSNMP')

and status = 'INACTIVE'

order by logon_time desc;

spool off

_at_htmloff

Sanjay

---

 This email is confidential and may also be privileged. If you are not the intended recipient, please notify us immediately and delete this message from your system without first printing or copying it. Any personal data in this email (including any attachments) must be handled in accordance with the Rio Tinto Group Data Protection Policy and all applicable data protection laws. †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Aug 21 2018 - 07:23:56 CEST