UPD_AD_SYNONYM Procedure

If the synonym name is found within the User Interface Default Attribute Dictionary, the synonym name is updated.

Syntax

APEX_UI_DEFAULT_UPDATE.UPD_AD_SYNONYM (
    p_syn_name           IN VARCHAR2,
    p_new_syn_name       IN VARCHAR2 DEFAULT NULL);

Parameters

Table: UPD_AD_SYNONYM Parameters describes the parameters available in the UPD_AD_SYNONYM procedure.

UPD_AD_SYNONYM Parameters

Parameter	Description
`p_syn_name`	Name of synonym to be updated
`p_new_syn_name`	New name for synonym

Example

The following example updates the CREATED_BY_USER synonym in the UI Defaults Attribute Dictionary within the workspace associated with the current schema.

BEGIN             
    apex_ui_default_update.upd_ad_column (
       p_syn_name     => 'CREATED_BY_USER',
       p_new_syn_name => 'USER_CREATED_BY');
END;