Denes Kubicek ApEx BLOG

This simple example is showing how to create a success message using dynamic actions. One thing needs to be mentioned though. The last one ...

This simple example is showing how to use a simple checkbox column in a tabular form to enable/disable or check/uncheck another checkbox co...

Yesterday an interesting question regarding tabular forms, collections and instant updates was asked in the Oracle APEX Forum . This example...

I know this is nothing new but I had a hard time to find out how to get the SQL of the currently viewed Interactive Report. In one of my pro...

Since APEX 4.0 cascading feature is a part of the standard. Not only a "normal" select list can be cascading but also a shuttle el...

There is a new plugin available which makes it possible to save and render contents larger than 32k. This limitation was one of the most cri...

It seem that there is a bug in APEX regarding deep linking, authentication and parsing special characters. See this thread . In this example...

I still remember how hard it was to make something like this working before the APEX version 4.0. You needed to create a function and then a...

If you need to create a dynamic SQL for a select list or any other type of a LOV, your query should not exceed 4000 characters. In case it d...

Sometimes you need to format a report column and if you need to do that in the report SQL, you will be faced with a problem while exporting...

APEX Collections is one of the best features of APEX. There are situations where solutions wouldn't be possible if this feature would no...

Today one of my customers upgraded their APEX 4.0 to 4.2.1.00.08. The whole process was completed without any issues. After the upgrade ther...

In this example at apex.oracle.com you can se how you can use an URL (which normaly provides a save/download dialog for saving or opening ...

This is the text of an email I received as a response after creating an account for my workspace and my demo application at apex.oracle.com...

Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir ( Dietmar Aust und ich) unser Oracle APEX: Knowhow aus der Praxis   Tra...

If you write a lot of PL/SQL code, sooner or later you will be faced with a requirement to count the number of occurrences of a substring in...

Did you know that an authentication function in APEX is not used the way a function actually should be used?   Normally, this function h...

It is now official - my friend Dietmar Aust is an Oracle ACE. C ongratulations . Well deserved.

The new Statement of Direction is touching a couple of interesting things. Here are the three most important: New Multi-Row Edit Region ...

Sometimes you will need to create your own processes for fetching values, validating and updating tables in a form. In some situations the w...