Reorder a Column
Use this API to reorder a Table's columns. You need to check out the Table definition whose columns you want to reorder.
Name
CDR_PUB_DF_TABLE.ReorderColumns
Signature
PROCEDURE REORDERCOLUMNS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_REORDEROBJCOLL IN CDR_REORDER_OBJ_COLL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
PI_REORDEROBJCOLL (Mandatory) This is a collection of CDR_REORDER_OBJ_TYPE that contains the Column objects that you want to reorder. The value for ENTRY_NUMBER must be NULL. Add the Columns to the collection in the new order in which you want them.
Parent topic: Create and Modify Tables