Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 |
|
|
Mobi · ePub |
retrieveNestedTableCommand = OMBRETRIEVE NESTED_TABLE "QUOTED_STRING" ( GET ( "getPropertiesClause" | "getReferenceIconSetClause" ) ) getPropertiesClause = PROPERTIES "(" "propertyNameList" ")" getReferenceIconSetClause = ( REF | REFERENCE ) ICONSET propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
Basic properties for NESTED_TABLE: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Nested Table Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Nested Table 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 Nested Table
Table 19-60 NESTED_TABLE 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. |