1.I have a table called EMPLOYEE having composite primary
keys defined on EMPNO,ENAME.
Now when I query from user_constraints:
where table_name = 'EMPLOYEE';
I get the information like:
Now I would like to know what is this SYS_C0098 etc.,
You need to look at the rest of the columns in that view - those 2 constraints are most likely NOT NULL constrainsts on your 2 PK columns.
Click Here to Expand Forum to Full Width