Identify Fields Primary Key

[Pablo]

Good morning guys ... I need to identify which columns are primary key via select ....

thanks for now

[victorhugomuniz]

Select all

 
select * from all_constraints where table_name = 'nomeTabela' and constraint_type = 'P' 

[Pablo]

Ow victor, thank you for force, but I wanted to know which column name is primary key ... type, cod_client .... but would have to be via select ...
thanks for the force.

[victorhugomuniz]

Select all

 
select column_name  
from all_cons_columns acc, 
     all_constraints ac 
where acc.table_name = ac.table_name 
     and ac.table_name = 'SUA_TABELA' 
     and ac.constraint_type = 'P' 

[dr_gori]

It has this query that I made a time ago: http://en.glufke.net/oracle/viewtopic.php?t=883
She shows the fields of constraints side by side