Hello geeks! In this post I have shared the details about “oracle get table key”. Okay, let’s move on to the post.
oracle get table key
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner FROM all_constraints cons, all_cons_columns cols WHERE cols.table_name="TABLE_NAME" AND cons.constraint_type="P" AND cons.constraint_name = cols.constraint_name AND cons.owner = cols.owner ORDER BY cols.table_name, cols.position;
I hope this tutorial helps you to know about “oracle get table key”. If you have any queries regarding this article please let us know via the comment section. Share this post with your friends & family via social networks.