Re: Which Oracle dictionary view gives information about the position of a column in a pr

From: mcstock <mcstock_at_enquery.com>
Date: Mon, 27 Oct 2003 23:59:23 -0500
Message-ID: <x5ednRTgEqKJZACiRVn-vg_at_comcast.com>

user_constraints and user_cons_columns

select
  uc.table_name

, uc.constraint_name
, ucc.position
, ucc.column_name

from
  user_constraints uc
, user_cons_columns ucc
where
  uc.table_name = ucc.table_name
and
  uc.constraint_name = ucc.constraint_name and
  uc.constraint_type = 'P'
and
  uc.table_name = '&table_name'
order by
  uc.table_name
, uc.constraint_name
, ucc.position

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048



"valexena" <member43815_at_dbforums.com> wrote in message
news:3525320.1067221684_at_dbforums.com...


>

> Which Oracle dictionary view gives information about the position of a

> column in a primary key?


>

>

> --

> Posted via http://dbforums.com

Received on Tue Oct 28 2003 - 05:59:23 CET