43.10 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 43-10 UPD_AD_SYNONYM Parameters
Parameter | Description |
---|---|
|
Name of synonym to be updated |
|
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_synonym (
p_syn_name => 'CREATED_BY_USER',
p_new_syn_name => 'USER_CREATED_BY');
END;
Parent topic: APEX_UI_DEFAULT_UPDATE