Code snippets for use with Oracle Application Express (APEX).

Is an animation effect which slowly slides up a region or page item. The effect looks much nicer than the built-in Hide dynamic action which immediately hides the component.

Is an animation effect which slowly slides down a region or page item. The effect looks much nicer than the built-in Show dynamic action which immediately shows the component.

Is an animation effect which slowly slides up or down a region or page item. The effect looks much nicer than the built-in show/hide dynamic action which immediately shows or hides the component.

This short anonomous block can be used to query data from the apex_collections view inside a PL/SQL IDE. After prompting you to define the workspace, application id and session it will allow you to access the apex_collections view as if you were running the queriy inside your APEX session.

This short anonomous block can be used to delete debug data from apex inside a PL/SQL IDE. After prompting you to define the workspace, application id and session it will loop through all of your applications and remove debug data.

These queries can be used to access information about any given page in an application. They can prove particularly useful for components on global pages (i.e. page 0).