| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 | 
 | 
| 
 | Mobi · ePub | 
retrieveVaryingArrayCommand =  OMBRETRIEVE VARYING_ARRAY "QUOTED_STRING" ( 
          GET ( "getPropertiesClause" | "getReferenceIconSetClause" ) )
     getPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
Basic properties for VARYING_ARRAY: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Varying Array Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Varying Array Name: DATATYPE Type: STRING(20) Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, SYS.ANYDATA, SYS.LCR$_ROW_RECORD, XMLFORMAT, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARHCAR, VARCHAR2, XMLTYPE Default: Empty string Datatype of the Base Element of the Varying Array
Table 21-13 VARYING_ARRAY Object
| Property | Type | Choices | Min | Max | Default | Description | 
|---|---|---|---|---|---|---|
| DEPLOYABLE | BOOLEAN | true, false | none | none | true | Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true | 
| GENERATION_COMMENTS | STRING | none | none | none | empty string | Enter additional comments for the generated code. |