Sample Header Ad - 728x90

Add ENum Attribute to existing table using Alter

2 votes
3 answers
8043 views
I am using oracle XE and trying to add a attribute that restricts to only three available value 'Small','Medium','large' to an existing table using Alter Table and Enum. Tried doing, ALTER TABLE TRUCK ADD TTYPE ENUM('SMALL','MEDIUM','LARGE'); but gets invalid option ALTER TABLE TRUCK ADD TTYPE ENUM('SMALL','MEDIUM','LARGE'); * where the error highlights after ENUM. I think I am having syntax error. Please help to resolve.
Asked by nubbear (23 rep)
Nov 3, 2014, 06:24 PM
Last activity: Sep 2, 2024, 04:30 PM