In my case, one schema does NOT have access to tables in other schema,
and I don't have right to grant access.
Brian Peasland wrote:
> zwasdl_at_gmail.com wrote:
> > I'm new to TOAD for Oracle. How can I create a query which gets data
> > from tables in different schema?
> >
> > Thanks,
> >
> > Wei
> >
>
> Provided you have access to that other table, use the schema-dot
> notation to reference tables owned by someone else. For instance:
>
> SELECT * FROM scott.emp;
>
> Notice "scott." to refer to the EMP table in the SCOTT schema.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Mon Oct 02 2006 - 13:24:00 CDT
