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 -> View problem...

View problem...

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Fri, 13 Nov 1998 18:52:02 +0800
Message-ID: <364C0F52.170E@comp.polyu.edu.hk>


Hello all,

	I create a view with a join table A and B.
	The view select fields from both table A and B. As a result, one table
is key-preserved table while the another is not.
	I cannot update or insert record to the non key-preserved table
throught this view. How can I update or insert record to the non key-preserved table by using view? Is it possible in Oracle 7.3.3 on Solaris 2.5?

Thanks,
Jimmy Received on Fri Nov 13 1998 - 04:52:02 CST

Original text of this message

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