Re: SQL*Plus - force TTitle to print regardless of query

How about issuing the call to dual with a TTITLE on, then switching TTITLE off for the real report ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

chrisoc_at_ans.net wrote in message <78skf1$kqj$1_at_nnrp1.dejanews.com>...
>
>
>All is well if the queries return rows but if they don't,
>there's just a "no rows returned" in a bunch of white space.
>If I issue a fake query to dual using noprint, that forces the TTitle
>but I can end up with two TTitles if the "real" query also returns rows.
>
Received on Fri Jan 29 1999 - 10:01:33 CST