Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
 

OMBALTER DRILL_TO_DETAIL

Purpose

Alters a drill to detail.

Prerequisites

Should be in the context of a business definition module or use the full path.

Syntax

alterDrillToDetailCommand =  ( OMBALTER DRILL_TO_DETAIL "QUOTED_STRING" ( (
           "renameClause" [ SET "setPropertiesClause" ] [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterDrillToDetailClauses" } ) | ( SET "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterDrillToDetailClauses" } ) | ( SET "setReferenceIconSetClause" 
          [ UNSET "unsetReferenceIconSetClause" ] { "alterDrillToDetailClauses" 
          } ) | ( UNSET "unsetReferenceIconSetClause" { 
          "alterDrillToDetailClauses" } ) | ( "alterDrillToDetailClauses" { 
          "alterDrillToDetailClauses" } ) ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterDrillToDetailClauses =  "addDrillToDetailReferenceClause" | UNSET ( 
          REF | REFERENCE ) "deleteDrillToDetailClauses"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addDrillToDetailReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     deleteDrillToDetailClauses =  ( ITEM "QUOTED_STRING" OF ITEM_FOLDER 
          "QUOTED_STRING" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterDrillToDetailCommand

This clause alters a drill to detail.

QUOTED_STRING

name of the drill to detail.

renameClause

Renames a drill to detail with a different name.

setPropertiesClause

This clause sets the properties of the object.

getPropertiesClause

Basic properties for DRILL_TO_DETAIL: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the drill to detail 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the drill to detail

setReferenceIconSetClause

Set specified Icon Set.

unsetReferenceIconSetClause

Unset specified Icon Set.

alterDrillToDetailClauses

This clause modifies a drill to detail.

propertyNameList

This is the list of property names.

propertyValueList

This is the list of property values.

addDrillToDetailReferenceClause

This adds a reference to an item to a drill to detail.

deleteDrillToDetailClauses

This deletes a reference to an item from a drill to detail.

propertyValue

This is a property value.

DRILL_TO_DETAIL Object

Table 2-9 DRILL_TO_DETAIL 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 objects marked as Deployable = true