title: Check Constraint in oracle for yes or no
body: <p>I have to create a table in an art gallery. the table is Art_Object. Among the various attributes, I am having trouble implementing a check constraint for a "Restoration" field where the only values for it can be "Yes" or "No". I have tried various versions of it with double quotations, single quotations, no quotations, making it equal the the field name (ex. Restoration = 'Yes') with no luck. I have also tried CHECK(Restoration IN('Yes', 'No'))... and this has not worked either. I am lost.</p>