zwasdl_at_gmail.com schreef:
> 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
>
In that case, you just found one of the
great things about Oracle: security!
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Oct 02 2006 - 13:46:36 CDT