This function gets the application alias for the application to be imported. This is only used if the application to be imported has an alias specified. An application alias must be unique within a workspace and it is recommended to be unique within an instance.
APEX_APPLICATION_INSTALL.GET_APPLICATION_ALIAS RETURN VARCHAR2;
The following example returns the value of the application alias value in the
APEX_APPLICATION_INSTALL package. The application alias cannot be more than 255 characters.
declare l_alias varchar2(255); begin l_alias := apex_application_install.get_application_alias; end;