Denes Kubicek ApEx BLOG

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...

http://www.apexblogs.info was a place I visited daily. A couple of days ago this domain was moved to http://www.odtug.com/apex . I am not s...

This function may help you if you need to report on columns with a lot of text. It will get rid of the carriage return and will help not to ...

The link to My Demo Application on apex.oracle.com has been changed from http://apex.oracle.com/pls/otn/f?p=31517:1 to https://apex.or...

Today, apex.oracle.com was updated to 4.2. My first impression was good - I haven't seen the early adopter this time. If you have an acc...

APEX can highlight the search string in a report if you enter the substitution string in the column property of your report - Highlight Word...

This is a quite simple but still frequently asked question. Here is an example on how to count checked rows in a tabular form. You may need ...

This small example shows how to create a textarea in a tabular form with a character counter, similar to the one for the page item of type ...

If you get the "ORA-01403: no data found" error after running your code while updating or validating a tabular form, you will need...