Re: SQL*Plus - NO RECORDS FOUND

From: Mike Androff <mja_at_idm.com>
Date: Thu, 17 Mar 1994 17:53:48 GMT
Message-ID: <CMtLpo.DLs_at_idm.com>


Alvin W. Law (alaw_at_oracle.com) wrote: : Instead of UNION, UNION ALL will do the trick.

UNION ALL is available only in Version 7, not 6.

Also, if you desire feedback to be on (i.e. '99 records/rows selected'), then the union'ed selection of the 'End of Report' row will cause that feedback number to be one greater than the number of 'real' records selected.

All for having a setting to get the title (and possibly the column headings) to print with no records selected, raise you hands! (I count one, two, three, ...) ;-)

                             Mike Androff
                             mja_at_idm.com
Received on Thu Mar 17 1994 - 18:53:48 CET

Original text of this message