In particular, I often look up constraints in SQL*Plus. ... The above query requires one to know the constraint name. The next query will show similar information for constraints on a given table.