Re: SQL*Plus - NO RECORDS FOUND

In article <CMtLpo.DLs_at_idm.com>, Mike Androff <mja_at_idm.com> wrote:
>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.

    The way to get around this in V6 is to add ROWID to the select list; before executing the query do

column rowid noprint

If you need to select multiple rowids from a join, just alias them:

column a_rowid noprint
column b_rowid noprint

select a.rowid a_rowid, b.rowid b_rowid ... union select NULL a_rowid, NULL b_rowid ...

This will do the same job as UNION ALL.

-- 
Mike Stein			The above represents the Absolute Truth.
POB 10420			Therefore it cannot possibly be the official
Arlington, VA  22210		position of my employer.