Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 |
|
|
Mobi · ePub |
Should be in the context of a module (Oracle, Non-Oracle, Aplications, Process Flow types) or a folder.
createUserFolderCommand = OMBCREATE ( FOLDER "QUOTED_STRING" [ SET "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | SET "setReferenceIconSetClause" ] ( { "addContainedObjClause" } ) ) setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING" addContainedObjClause = ADD CONTAINED_OBJECT "containedObjTypeClause" "QUOTED_STRING" propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } containedObjTypeClause = ( TABLE | VIEW | PACKAGE | DIMENSION | MATERIALIZED_VIEW | SEQUENCE | CUBE | DATA_AUDITOR | ADVANCED_QUEUE | QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | NESTED_TABLE | MAPPING | PLUGGABLE_MAPPING | PROCESS_FLOW_PACKAGE | FUNCTION | TABLE_FUNCTION | PROCEDURE ) propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Basic properties for FOLDER: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: NAME Business name of a Folder Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of a Folder
The type of the contained object to be added. Valid object types are: TABLE | VIEW | PACKAGE | DIMENSION | MATERIALIZED_VIEW | SEQUENCE | CUBE | ADVANCED_QUEUE | STREAMS_QUEUE | QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | NESTED_TABLE | MAPPING | PROCESS_FLOW_PACKAGE | FUNCTION | PROCEDURE.