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 -> O7.3 Updatable join view: key-preserved table

O7.3 Updatable join view: key-preserved table

From: Gerard H. Pille <gerard_h_pille_at_hotmail.com>
Date: 1997/04/30
Message-ID: <01bc50eb$0841d500$3e0d4ac1@PCGHP>#1/1 







Hello,



Any idea how one could determine which table(s) of an updatable join view
(Oracle 7.3) are key-preserved?



I can find the tables via user_dependencies, and the updatable columns via
user_updatable_columns, but joining those fails if the tables contain
columns with the same name.



Kind regards,



Gerard (ghp_at_santens.com)
Received on Wed Apr 30 1997 - 00:00:00 CDT












Original text of this message













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