Data Use Case Domains
Oracle Database 23ai introduces Data Use Case Domains, 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 use case 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 Data Use Case 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 Data Use Case Domains, as well as retrieving Data Use Case Domains schema and name information using OracleDataReader.GetSchemaTable()
. The SchemaTable
has two columns, DomainName
and DomainSchema
, that stores this information.