Actually I would like to accomplish the same as op in the old question:
Way to Update An Existing Application Alias From SQL Prompt? (0 Bytes)flow:
deploy application_id 23 to production with alias: devfoobar23
change current prod applications (22) alias to : obsoletedfoobar22
prevent access to obsoleted22 with suitable message
change new prod applications 23 alias to : prodfoorbar
So how to do change of alias with plsql?
And if possible how to prevent access to application with plsql?
rgrds Paavo
ps. Apex 21.1.5