Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

column default with ENUM

Mike KutzMay 23 2024 — edited May 23 2024

I can create a column with a default enum value. But, the default value isn't valid during insert.

Example code:

create domain status_d as enum ( initializing, analyzing, curating, finalized, deprecated );

create table test_col (
   id int generated always as identity
  ,my_status status_d default on null hr.status_d.initializing -- adjust schema as needed
  ,some_data varchar2(50)
);

-- these fail with ORA-00984: column not allowed here
insert into test_col ( some_data ) values
('abc');
insert into test_col ( some_data, my_status ) values
('abc', default);

-- this works
insert into test_col ( some_data, my_status ) values
('abc', status_d.initializing);

-- but, this fails
insert into test_col ( some_data, my_status ) values
  ('abc', status_d.initializing),
  ('def', status_d.initializing);

DB: 23.4 VirtualBox

This post has been answered by MartinBach-Oracle on Jun 11 2024
Jump to Answer
Comments
Post Details
Added on May 23 2024
3 comments
429 views