Category: Tip

What should you do if you have an anydata column in a queue table and you don’t have any tool to read from it(sqldeveloper doesn’t support it natively)? I have written some code to extract all the information from such a column and print it, whatever the content would be. You can find out more

Apex: Report Sort Option showing strange behaviour … A few days ago I was making a basic report page in ApEx, but when I tried to run the page I got the next error: Although the report was based on a simple select-from-one-table, it took me quite some time to found out what went wrong: […]

Apex: Using a Date Format Mask at Application Level Every Apex application contains a lot of report pages with date columns and form pages with date fields. For all these items you can specify a date format mask. Never asked yourself if it is possible to define that format mask only once at a central […]

Apex: How to Disable a Text Area ? Every application contains pages where the data should be displayed in read-only mode. For a normal text item, you can declare a field as “Display as Text Item (does not save state)” and the value is shown as HTML(see Text 1). For a multi-line text area there […]

Apex: Caveat PK column name length It is highly encouraged in Apex to use system generated, single primary key columns whenever possible. When choosing multi-column, composed primary keys, you quickly get in trouble when dealing with the standard MRU Processes. This is limited to handling tables with at most a 2 column primary key. So, […]

ApEx Sample Application … Great … But … Creating the sample application by default is a nice idea within Apex.It is simple. You define a new workspace, and you get if for free … Great … When you are a newbie, this application gives you a good idea of the possibilities of the tool. But […]