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