sql question help !!
select ac.constraint_name key_name, acc.column_name key_col, 1
from all_cons_columns acc, all_constraints ac
where acc.owner = ac.owner
and acc.constraint_name = ac.constraint_name
and acc.table_name = ac.table_name
and ac.constraint_type = 'P'
and ac.owner = :OwnerName
and ac.table_name = :TableName
order by acc.constraint_name