Command Not Properly Ended

[Dario1984]

Hi,

I'm just starting out in the world of SQL and I wrote some code and got an error like this :
SQL>
SQL> ALTER TABLE Book
2 MODIFY CONSTRAINT Book_CHK1
3 (topic IN ('ART', 'ARCHITECTURE', 'BIOGRAPHY', 'CHILDREN', 'COMPUTER',
4 'COOKING', 'FOOD AND WINE', 'GARDENING', 'HEALTH', 'HISTORY', 'GEOGRAPHY',
5 'SCIENCE','RELIGION', 'ROMANCE', 'SPORT', 'OTHER' ));
(topic IN ('ART', 'ARCHITECTURE', 'BIOGRAPHY', 'CHILDREN', 'COMPUTER',
*
ERROR at line 3:
ORA-00933: SQL command not
properly ended

Could anyone who has experinced this tell me what's wrong ? If I put it all on one like without Enter characters, it still doesn't work.

 

[juliane26]

This being an Oracle DDL/SQLPlus questions, you are better of with other forums:
9i:

http://www.tek-tips.com/threadminder.cfm?pid=759

10g:

http://www.tek-tips.com/threadminder.cfm?pid=1177

Constraints are always database specific and don't come with ANSI SQL.

anyway for a quick response:
I suppose this is a check constraint, so the keyword CHECK is actually missing between the constraint name and the condition


Juliane