If the column name is found within the User Interface Default Attribute Dictionary, the synonym provided is created and associated with that column. Synonyms share the column definition of their base column.
APEX_UI_DEFAULT_UPDATE.ADD_AD_SYNONYM ( p_column_name IN VARCHAR2, p_syn_name IN VARCHAR2);
Table 27-2 ADD_AD_SYNONYM Parameters
Name of column with the Attribute Dictionary that the synonym is being created for.
Name of synonym to be created.
The following example add the synonym CREATED_BY_USER to the CREATED_BY attribute of the UI Defaults Attribute Dictionary within the workspace associated with the current schema.
BEGIN apex_ui_default_update.add_ad_synonym ( p_column_name => 'CREATED_BY', p_syn_name => 'CREATED_BY_USER' ); END;