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
Mobi · ePub

OMBRETRIEVE LIST_OF_VALUES

Purpose

Retrieve details of a List Of Values.

Prerequisites

Should be in the context of a Business Definition Module or use the full path.

Syntax

retrieveListOfValuesCommand =  OMBRETRIEVE LIST_OF_VALUES "QUOTED_STRING" 
          "retrieveListOfValuesClauseDetails"
     retrieveListOfValuesClauseDetails =  GET ( 
          "getPropertiesClauseforLOVandD2D" | "getReferenceIconSetClause" | ( 
          REF | REFERENCE ) DEFINING ITEM | ( REF | REFERENCE ) ITEMS | 
          DEPENDENTS )
     getPropertiesClauseforLOVandD2D =  PROPERTIES "(" 
          "propertyNameListforLOVandD2D" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     propertyNameListforLOVandD2D =  ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) { 
          "," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }

Parameters

retrieveListOfValuesCommand

Retrieves the list of values.

QUOTED_STRING

name of the list of values.

retrieveListOfValuesClauseDetails

This clause retrieves the contents of a list of values.

GET

This clause retrieves the following

REF DEFINING ITEM retrieves the Item that holds the individual values for this list of values.

REF ITEMS retrieves the list of Items that use this list of values.

DEPENDENTS retrieves a list of Item Folders that the list of values depends on.

(This will return the Item Folder containing the Values Item).

getPropertiesClauseforLOVandD2D

This clause gets the properties of the object.

getPropertiesClauseforLOVandD2D

Basic properties for LIST_OF_VALUES: 

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

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

Name: DRILL_TO_DETAIL
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether the list of values enables drilling between the item folders containing the items that use the list of values 

Name: RETRIEVE_VALUES_GROUP_SIZE
Type: Number
Valid Values: Any valid character string in supported character set.
Default: '100'
The number of rows to be fetched from the database at a time 

Name: CACHE_VALUES
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the list of values should be cached in memory 

Name: REQUIRE_SEARCH
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether search criteria should be requested 

Name: SHOW_IN_NAVIGATOR
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be shown in the item navigator 

Name: SORTED_DISTINCT
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be displayed sorted with duplicates hidden

getReferenceIconSetClause

Get specified Icon Set.

propertyNameListforLOVandD2D

This is the list of property names.

LIST_OF_VALUES Object

Table 19-5 LIST_OF_VALUES 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