Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with query across schema in TOAD

Re: Help with query across schema in TOAD

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 2 Oct 2006 14:03:09 -0700
Message-ID: <1159822989.493392.143570@m7g2000cwm.googlegroups.com>

zwasdl_at_gmail.com wrote:
> I can connect to different schema via different accounts, and MS Access
> can have cross-schema query with linked tables. Does TOAD have similar
> capability? Or I have to ask for creating a schema which has access to
> all the necessary tables in multiple schema?
>
> Basically, I'm asking for a combination of Access and TOAD for Oracle,
> which has the following capabilities:
> 1. Query across multiple schema in Oracle
> 2. Use hint to control query plan
> 3. Interactive interface on building queries.
>
> Any suggestion is appreciated!
>
> Thanks,
>
> Wei

Why don't you talk to the appropriate dba or senior developer or your manager? Received on Mon Oct 02 2006 - 16:03:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US