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.