[Polantaris]

I'm a little new to Oracle. Regardless, I've been doing assignments in my Database class with usually decent success without much trouble. I hit an issue where I need to add several constraints to a new attribute column in an existing table, and I'm getting errors with the attempts.

I need to alter a table to add a new attribute column, give it a constraint to enforce a domain of three specific values, and a second constraint of a default value.

ALTER TABLE VIDEO
ADD VID_STATUS VARCHAR(4) NOT NULL
ADD CONSTRAINT VID_STAT1 CHECK(VID_STATUS IN('IN','OUT','LOST'))
ADD CONSTRAINT VID_STAT2 DEFAULT VID_STATUS = 'IN';

With that code, I am getting an ORA-00904: Invalid Identifier error on DEFAULT on the 4th line. Before this attempt, I tried combining the constraints into one constraint, and I would get an error on the first opening parenthesis of the following attempted line (Same Error):

ADD CONSTRAINT VID_STAT1(CHECK(VID_STATUS IN('IN','OUT','LOST')) AND DEFAUlT VID_STATUS = 'IN');

I thought I read somewhere that Oracle doesn't support the DEFAULT Constraint? If so, how would I set up a DEFAULT of this nature? My book acts like there is a DEFAULT Constraint that I can use, but an invalid identifier error makes me think there isn't, but I can't find anything to replace it with.

Any help would be great.

[Polantaris]

I can't find an Edit button so:

Nevermind about this, I figured the problem out.

ALTER TABLE VIDEO
ADD VID_STATUS VARCHAR(4) DEFAULT 'IN' NOT NULL
ADD CONSTRAINT VID_STAT1 CHECK(VID_STATUS IN('IN','OUT','LOST'));

The above worked. Sorry for posting this.

[Atli]

Hey.

Glad you found the solution. Thanks for sharing it!

I edited the topic title a bit, by the way, to make it clearer what the problem was. Might make it easier for some Googler to find your solution.