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: ebuddelm <ebuddelm_at_gmail.com>
Date: 3 Oct 2006 01:32:17 -0700
Message-ID: <1159864337.144256.183560@k70g2000cwa.googlegroups.com> 





Hi Wei,



You can prefix the table_name with the schema name as in schema.table.
You can also create a synonym that has the same name as the table name
in the other schema.


create or replace synonym <table> for <schema>.<table>



It's all in the manuals BTW.



Regards,


Eric.



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

Received on Tue Oct 03 2006 - 03:32:17 CDT












Original text of this message













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