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 -> Which cols are part of the primary key?

Which cols are part of the primary key?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 20 Mar 2006 15:42:33 +0100
Message-ID: <dvmf0p$vai$3@nntp.fujitsu-siemens.com> 





Hi!


Given a table, is there a way, using SQL, to figure out,
which columns are part of the primary key?
Given two tables, I'd like to create the "on" condition
of a merge statement.



Lots of Greetings and Thanks!


Volker



PS: 9.2.0.6, Linux. If there's a way in 10g I'd be grateful too.
Received on Mon Mar 20 2006 - 08:42:33 CST












Original text of this message













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