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
Last activity: Sep 2, 2024, 04:30 PM