How to can I display headers from the tables if I get "no rows selected" output ?
Hello,
I"m was wondering if there is a way to display columns headers even if I get no results "no rows selected" output.
This is the query that I'm running it just checks if there any not encrypted tablespaces within database.
SELECT ts.tablespace_name, et.MASTERKEYID, ts.encrypted, et.encryptionalg, ts.STATUS, d.NAME, i.host_name
FROM dba_tablespaces ts, v$encrypted_tablespaces et, v$tablespace t, v$instance i, v$database d
WHERE t.ts# = et.ts# AND ts.tablespace_name = t.name and ts.tablespace_name not in ('SYSTEM','SYSAUX','UNDOTBS1') and CONTENTS <> 'TEMPORARY' and ENCRYPTED='NO';