primary keys

[julian]

select
        TABLE_NAME, CONSTRAINT_NAME, STATUS
from
        DBA_CONSTRAINTS
where
        owner = 'ABC' and constraint_type = 'P'
order by
        TABLE_NAME desc;