SQL Domains

Oracle Database 23ai introduces SQL domain, a dictionary object that belongs to a schema and encapsulates a set of optional properties and constraints for common values, such as credit card numbers or email addresses. After you define a SQL domain, you can define table columns to be associated with that domain, thereby explicitly applying the domain's optional properties and constraints to those columns.

With SQL domains, you can define how you intend to use data centrally. They make it easier to ensure you handle values consistently across applications and improve data quality.

All ODP.NET provider types support using SQL domains, as well as retrieving SQL domain schema and name information using OracleDataReader.GetSchemaTable(). The SchemaTable has two columns, DomainName and DomainSchema, that stores this information.