467,910 Members | 1,669 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,910 developers. It's quick & easy.

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


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
  • viewed: 7873
Share:
3 Replies
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
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
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.

Similar topics

27 posts views Thread by Nasir | last post: by
8 posts views Thread by =?Utf-8?B?eWRibg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.