Skip navigation.

Tony Andrews

Syndicate content
Some very occasional musings on matters concerning Oracle specifically or databases in general.Tony Andrews
Updated: 15 hours 33 min ago

Handy pre-defined Oracle collections

Sat, 2014-08-30 05:09
Note to self: SYS.DBMS_DEBUG_VC2COLL is a handy pre-defined TABLE OF VARCHAR2(1000) SYS.KU$_VCNT is TABLE OF VARCHAR2(4000) Both are granted to public. Thanks to Eddie Awad's blog for these. Tony Andrews

Hiding APEX report pagination when trivial

Tue, 2014-06-10 11:33
The users are quite happy with pagination like this: However, they don't like it when the report returns less than a pageful of rows and they see this: (Fussy, I know). This is one way to do it.  First, ensure that the pagination area itself is identifiable.  I put a div around it with a class of "pagination": Then add some Javascript to the "Execute when page loads" attribute of theTony Andrews

APEX boilerplate translation

Mon, 2014-05-26 09:25
APEX provides a mechanism for translating applications into other languages: Applications can be translated from a primary language into other languages. Each translation results in the creation of a new translated application. Each translation requires a mapping which identifies the target language as well as the translated application ID. Translated applications cannot be edited directly in Tony Andrews