47.2 ADD_AD_SYNONYM Procedure
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.
Syntax
APEX_UI_DEFAULT_UPDATE.ADD_AD_SYNONYM (
p_column_name IN VARCHAR2,
p_syn_name IN VARCHAR2);
Parameters
Table 47-2 ADD_AD_SYNONYM Parameters
Parameter | Description |
---|---|
|
Name of column with the Attribute Dictionary that the synonym is being created for. |
|
Name of synonym to be created. |
Example
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;
Parent topic: APEX_UI_DEFAULT_UPDATE