Denes Kubicek ApEx BLOG

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

I just received an interesting question regarding report filtering. The problem was the following: 1. There was a checkbox with multiple c...

Using a DB Link to query BLOB's from a remote database could be a problem. Recently, I had to show images comming from a remote server i...

Our next training is scheduled for March 2012. You can find the deatils on www.opal-consulting.de . ----------------------------------------...

Creating two level tabs page layout in APEX is still a problem. I just had an application where I created a parent tab set and then a standa...

If you use PL/SQL functions in your branch conditional processing you should be sure your code works. I just had a case where I added someth...