Denes Kubicek ApEx BLOG

Quite often there is a misunderstanding between displaying of a value and sorting upon the same. ApEx reports are giving you a possibility t...

One of frequently asked questions in the forum is "how to put more than one region in a region?". For example a report and a list ...

I have been asked many times about a possibility to get some good training for ApEx. I think, there is an oracle two-day training on basics....

If you need to use the apex_collection.crate_collection_from_query package, you will need to replace your :P_ITEM binds with v('P_ITEM...

This is one of frequently asked questions: "I have only a few lines of data - mostly some dates with a duration from > to - and woul...

I have been using SQL for years and from time to time I stumble upon a problem, where I needed to count the occurrence of a character or a s...

This is one of the frequently asked questions in the ApEx forum. I created an example on how to build a form which will work similar to the ...

The packages for Export to Excel for ApEx and XE are now unwrapped and available for download: http://htmldb.oracle.com/pls/otn/f?p=31517:10...

Understanding the syntax of javascript is a hard piece of work. I have to admit, that I just started to understand some small portions of it...

Many questions in the ApEx Forum are related to the way of creating custom search forms and implementation of different page elements in qu...

There are only very few things in ApEx you could describe as critical. One of those, for sure, are checkboxes in tabular forms. I had a requ...

Very often I get asked if ApEx can do this or that, what usually is a functionality available in Oracle. Recently, there was a question if u...

I received couple of emails asking me how to export a report to an .xml file. Therefore I decided to create a small package and a demo appli...

This problem is quite old. Many times my users complained getting no output when they try to export what they see in a report. I just found ...

I never thought so many people from all arround the world will visit my Apex Demo Application . Yesterday, I saw more than 4000 pageclicks. ...

Couple of days ago, I was asked by Dimitri and John if I would like to join their project called ApEx Evangelists . This was an offer you ca...

One of the most anoying things my users complain about (and all the time) is export of reports to excel. Let us not talk about how much sens...

So, let's start blogging. It took me a half a year to make that decission and to start doing it. I am going to focus my blogs on ApEx de...