OMBALTER NESTED_TABLE

Purpose

Alter the Nested Table by resetting its properties.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

alterNestedTableCommand =  OMBALTER ( NESTED_TABLE "QUOTED_STRING" ( 
          "renameClause" [ "alterPropertiesOrIconSetClause" ] | 
          "alterPropertiesOrIconSetClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET ( REF |
           REFERENCE ) "setReferenceIconSetClause" | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause" ] | ( REF | REFERENCE ) 
          "setReferenceIconSetClause" ) | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterNestedTableCommand

Alters a Nested Table of the given name by either renaming it, or by setting it's properties or a combination of these.

renameClause

renames a table with a different name.

alterPropertiesOrIconSetClause

Alters Nested Table properties or icon set.

setPropertiesClause

Sets properties (core, logical, physical, user-defined) for Nested Table

getPropertiesClause

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

setReferenceIconSetClause

Sets reference icon set.

unsetReferenceIconSetClause

Unsets reference icon set.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

NESTED_TABLE Object

Table 3-57 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.