Home » SQL & PL/SQL » SQL & PL/SQL » Re: check constraints
Re: check constraints [message #3563] Thu, 03 October 2002 22:19
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try issuing this query when connected as the table owner:

select search_condition
from user_constraints
where constraint_name = 'SYS_C00916';

The query will show the condition that makes the insert fail. A check constraint violation means that you didn't meet the criteria stipulated in the check constraint.

HTH,
MHE

Report message to a moderator

Previous Topic: Problem with Order by desc when used with group by
Next Topic: Define SQL*PLUS editor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 23:00:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.