A trivial solution is to union all that with selecting the correct number of
nulls from dual, as long as you are not processing the row by row results.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sanjay Mishra (Redacted sender "smishra_97" for DMARC)
Sent: Monday, August 20, 2018 8:27 PM
To: Oracle-L Freelists
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
@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
@htmloff
Sanjay
