By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,206 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,206 IT Pros & Developers. It's quick & easy.

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

P: n/a

Which Oracle dictionary view gives information about the position of a
column in a primary key?
--
Posted via http://dbforums.com
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
valexena wrote:

Which Oracle dictionary view gives information about the position of a
column in a primary key?

--
Posted via http://dbforums.com


The one that displays info about constraint columns

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]
Jul 19 '05 #2

P: n/a
valexena <me*********@dbforums.com> wrote in message news:<35****************@dbforums.com>...
Which Oracle dictionary view gives information about the position of a
column in a primary key?


You might want to check out the following two articles to get familar
with the Oracle RDBMS dictionary

How do I find information about a database object: table, index,
constraint, view, etc… in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to
access a given object ?
http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell --
Jul 19 '05 #3

P: n/a
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" <me*********@dbforums.com> wrote in message
news:35****************@dbforums.com...

Which Oracle dictionary view gives information about the position of a
column in a primary key?
--
Posted via http://dbforums.com

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.