We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
A feature that hasn't been announced earlier in Oracle 23c (now 23ai) is enumeration domains!
We'll add support for this as well in:
USECASE
NUMBER
1
ALL_DOMAINS
ALL_DOMAIN_COLS
ALL_TABLES
After a quick glance, it seems quite different from PostgreSQL's implementation:
-- Ordinal enums create domain dow_n as enum ( mon, tue, wed, thu, fri, sat, sun ); create domain dow_s as enum ( monday = mon = 'MO', tuesday = tue = 'TU', wednesday = wed = 'WE', thursday = thu = 'TH', friday = fri = 'FR', saturday = sat = 'SA', sunday = sun = 'SU' );
And then:
select * from dow_n;
Produces:
|ENUM_NAME|ENUM_VALUE| |---------|----------| |MON |1 | |TUE |2 | |WED |3 | |THU |4 | |FRI |5 | |SAT |6 | |SUN |7 |
Whereas:
select * from dow_s;
Is:
|ENUM_NAME|ENUM_VALUE| |---------|----------| |MONDAY |MO | |MON |MO | |TUESDAY |TU | |TUE |TU | |WEDNESDAY|WE | |WED |WE | |THURSDAY |TH | |THU |TH | |FRIDAY |FR | |FRI |FR | |SATURDAY |SA | |SAT |SA | |SUNDAY |SU | |SUN |SU |
Also:
select dow_s.mon;
|MON| |---| |MO |
And:
create table t (n dow_n, s dow_s); insert into t values (1, dow_s.mon); select domain_display(n), domain_display(s) from t;
|DOMAIN_DISPLAY(N)|DOMAIN_DISPLAY(S)| |-----------------|-----------------| |MON |MONDAY |
Related work:
The text was updated successfully, but these errors were encountered:
No branches or pull requests
A feature that hasn't been announced earlier in Oracle 23c (now 23ai) is enumeration domains!
We'll add support for this as well in:
USECASE
keyword. Meaning unclear, see: https://forums.oracle.com/ords/apexds/post/create-usecase-domain-isn-t-explained-in-23ai-documentation-2024NUMBER
, starting from1
) by defaultALL_DOMAINS
,ALL_DOMAIN_COLS
) is created. It isn't listed inALL_TABLES
, though!After a quick glance, it seems quite different from PostgreSQL's implementation:
And then:
Produces:
Whereas:
Is:
Also:
Is:
And:
Is:
Related work:
The text was updated successfully, but these errors were encountered: