I created the following domain in a version 23.5 free instance (also tried version 23.6 in an autonomous database instance with the same result) :
create domain if not exists dbl_identifier
as raw(16) strict
-- formatted 36 character GUID
display substr(rawtohex(dbl_identifier), 1, 8)
|| '-' || substr(rawtohex(dbl_identifier), 9, 4)
|| '-' || substr(rawtohex(dbl_identifier), 13, 4)
|| '-' || substr(rawtohex(dbl_identifier), 17, 4)
|| '-' || substr(rawtohex(dbl_identifier), 21, 12);
When I use this domain in a table I can see its data type. However, where do I find the domain data type in the data dictionary?
all_domains does not contain the data type of a domain. Is this information missing?
Any help is appreciated.
Thanks.