查询oracle表字段并判断是否主键

select a.column_name name,case when a.column_name=t.column_name then 1 else 0 end isKey
from user_tab_columns a
left join (select b.table_name,b.column_name from user_cons_columns b
join user_constraints c on c.CONSTRAINT_NAME=b.CONSTRAINT_NAME
where c.constraint_type   ='P') t
on a.table_name=t.table_name
where a.table_name='TEST';