Sunday, January 31, 2016

Oracle select primary key name

Dear my readers

here I present example for how to select the primary key name which existing inside the table user_constraints

select constraint_name
from user_constraints
where constraint_type = 'P'
and table_name = upper('emp_eff')
/

hope useful for all

for any question you can email me on yasser.hassan@yandex.com
Yasser