Re: select across owner

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 25 Mar 2003 10:07:27 +0800
Message-ID: <3E7FB9DF.2A89@yahoo.com>

Lucas Stevens wrote:
>
> Hi,
>
> Newbie here,
>
> How do you select across owners with the same tablename?
>
> Ex
>
> SELECT FirstName
> FROM [all owner of].employee
>
> Lucas

If you want to do with with plain old SQL you will need to code them explicitly:

select * from owner1.employee
union all
select * from owner2.employee
union all

etc etc

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Mon Mar 24 2003 - 20:07:27 CST