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 -> select data from different database

select data from different database

From: skyloon <skyloon_at_gmail.com>
Date: 24 Nov 2006 01:24:46 -0800
Message-ID: <1164360286.299418.163010@l12g2000cwl.googlegroups.com> 





hi,


may I know how to select data from different database?



for example,


I've 2 databases, OracleDB and OracleAR


Connect with OracleAR in SQL*Plus



select * from OracleDB.TableName



does Oracle support this kind of query?



how can I retrieve data from other database while im connecting with
other database?
Received on Fri Nov 24 2006 - 03:24:46 CST












Original text of this message













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