查询Oracle表的PK列

[gjwang1983]

数据库在Unix Server上，我通过终端sqlplus登陆后，想查询一个数据库里的某张表的PK列。请问如何查询？
$sqlplus username/password@tnsname
SQL> desc table_1
a number(38)
b varchar(100)
SQL> how to query the PK columns of table_1 ?

[suncrafted]

SELECT T.OWNER,T.TABLE_NAME,T.CONSTRAINT_NAME AS PRI_KEY FROM ALL_CONSTRAINTS T
WHERE T.OWNER = UPPER('username')
AND T.TABLE_NAME = UPPER('table_1')
AND T.CONSTRAINT_TYPE = 'P'

[superhsj]

select * from user_cons_columns where constraint_name= 
(select constraint_name from user_constraints where table_name = '表名大写' and  constraint_type   ='P');  

[inthirties]

[Quote=引用 2 楼 superhsj 的回复:]
SQL code
select * from user_cons_columns where constraint_name=
(select constraint_name from user_constraints where table_name = '表名大写' and constraint_type ='P');


[/Quote]

这个不错