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

Home -> Community -> Usenet -> c.d.o.misc -> Tables from two databases

Tables from two databases

From: Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK>
Date: 16 Nov 1999 15:47:53 GMT
Message-ID: <80rub9$ms$1@power25t.hkbu.edu.hk> 





Hi,



I have two tables (with same definition and structure but
different contents) from two separate databases.



I want to create a view to select, update, delete from
two tables.  Any update will do in according to some
constraints to the database (db1 or db2). How to do it?



EG,   table a1 (name varchar2(2)) at db1 and 


            a2 (name varchar2(2)) at db2



      view  v1 =  a1+a2



Thanks for help.



-- 


Johnson Chow
Received on Tue Nov 16 1999 - 09:47:53 CST












Original text of this message













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