Presetting workspace name and username: quick tip for the lazy apex developer

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

A quick tip for the lazy apex developers like me.
If you manage many workspaces on different machines and servers, you may want to create several bookmarks to quickly preset the workspace name and the workspace administrator name or an application developer name if you prefer.

Being Apex a tool written with Apex itself, it's easy to preset the page items in the following fashion:

http://hostname/path/f?p=4550:1:::::F4550_P1_COMPANY,F4550_P1_USERNAME:WORKSPACE,USERNAME

just replace the various the parameters like hostname, path, WORKSPACE and USERNAME with the corresponding values.

For instance:

http://localhost/apex/f?p=4550:1:::::F4550_P1_COMPANY,F4550_P1_USERNAME:INTERNAL,ADMIN

the bookmark works for the standard apex super administrator in a typical Oracle XE installation and it is practically equivalent to:

http://localhost/apex/apex_admin

If you have an account on apex.oracle.com, supposing you have a workspace named ACME with an administrator called CERBERUS, then your bookmark becomes:

http://apex.oracle.com/pls/otn/f?p=4550:1:::::F4550_P1_COMPANY,F4550_P1_USERNAME:ACME,CERBERUS

If you manage a single workspace this is of little use, but if you deal with dozens of them it can definitely help.

Do not use this method to store the password in clear text inside the bookmark, if you don't want to type the password every time, then turn on the password wallet feature of the browser.

See more articles about Oracle Application Express or download tools and utilities.

PS: if you ever watched looney tunes cartoons, then you'll remember that ACME was the brand printed on any box of any item handled by bugs bunny, wil coyote, duffy duck, speedy gonzalez and so on. I read somewhere (on IMDB perhaps?) that ACME stood for "A Company that Makes Everything" :-)