SQL Language (MOSC)

MOSC Banner

How to can I display headers from the tables if I get "no rows selected" output ?

edited Oct 1, 2019 11:49AM in SQL Language (MOSC) 4 commentsAnswered ✓

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';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center