Oracle Primary key

[MsmVc]

Hi all how can i get Primary key column name from table?I find some tips from google but it's not working always show no row selected.

select all_constraints.index_name, all_ind_columns.column_name, all_ind_columns.column_position from all_constraints, all_ind_columns where all_constraints.owner = all_ind_columns.index_owner and all_constraints.constraint_name = all_ind_columns.index_name and all_constraints.constraint_type = 'P' and all_constraints.owner = 'DBO' and all_constraints.table_name = UPPER('VARTABLE') order by all_constraints.index_name asc, all_ind_columns.column_position asc, all_ind_columns.column_name asc

please help me.

[Mycroft Holmes]

try hitting the enter key sometime!

Never underestimate the power of human stupidity RAH

[MsmVc]

ok next time.

[David Skelly]

Try this: http://www.techonthenet.com/oracle/questions/find_pkeys.php[^]