| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 | 
 | 
| 
 | Mobi · ePub | 
Domain is a type with constraints on some other type. For example, you can define a domain which contains a list of valid values of some existing type, or you can define a domain which contains ranges of some existing type.
parseDefineDomainCommand =  OMBDEFINE DOMAIN_DEFINITION "QUOTED_STRING" [ (
           ON | OF ) "modelClause" ] "setDomainPropertiesClause" { 
          "addRangeClause" | "addValueClause" }
     modelClause =  ( MODEL "QUOTED_STRING" | PLATFORM "QUOTED_STRING" | 
          CONFIGURATION_TEMPLATE "QUOTED_STRING" ( ON | OF ) PLATFORM 
          "QUOTED_STRING" )
     setDomainPropertiesClause =  SET PROPERTIES "(" "propertyNameList" ")" 
          VALUES "(" "propertyValueList" ")"
     addRangeClause =  ADD RANGE_DEFINITION "QUOTED_STRING" 
          "setRangePropertiesClause"
     addValueClause =  ADD DOMAIN_VALUE "QUOTED_STRING"
     propertyNameList =  "propertyNameClause" { "," "propertyNameClause" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setRangePropertiesClause =  SET PROPERTIES "(" "propertyNameList" ")" 
          VALUES "(" "propertyValueList" ")"
     propertyNameClause =  ( "UNQUOTED_STRING" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
Set the properties on the domain. Valid properties are BASE_TYPE, DESCRIPTION.
Set the properties on the range. Valid properties are MIN_VALUE_STRING, MIN_VALUE_INCLUSIVE, MAX_VALUE_STRING, MAX_VALUE_INCLUSIVE, DESCRIPTION. MIN_VALUE_STRING is the minimum value for this range. MIN_VALUE_INCLUSIVE equal to true means the minimum value is in the range. MAX_VALUE_STRING is the maximum for this range. MAX_VALUE_INCLUSIVE equal to true means the maximum value is in the range.