Oracle, how to use the OWNER as conditions, query the current user name, I'm going to query a constraint, the constraint in a lot of users have, of course, so I need to query the current user name, I remember there is a way, but forget...

CodePudding user response:

User_constraints
Or dba_constraints all_constraints with owner field filtering,

CodePudding user response:

reference 1st floor minsic78 response:

user_constraints
Or dba_constraints all_constraints with owner field filtering,

Dba_constraints view need to have permission to access, not reluctantly ~