Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with query across schema in TOAD
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" - UnknownReceived on Mon Oct 02 2006 - 13:06:37 CDT
![]() |
![]() |