<p>All I know about the constraint is it's name (<code>SYS_C003415</code>), but I want to see it's definition.</p>

Looks like I should be querying
```
ALL_CONSTRAINTS
```
.
```
```
select OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION from ALL_CONSTRAINTS where CONSTRAINT_NAME = 'SYS_C003415';
```
```