The MySQL enum column type is useful for enforcing constraints on your text data columns. We’ll look at how to emulate this functionality in Oracle using standard SQL constraints. As an example, let’s look at a simple MySQL comments table.
CREATE TABLE comments(
comment_text text,
comment_type ENUM (’spam’, […]
