My 5 favorite sessions at ODTUG Kscope17

In a few weeks this years ODTUG Kscope conference will take placed in San Antonio, Texas, US.

Time to share my 5 favorite sessions at this awesome and inspiring conference.

By know it should be common knowledge that I attend conferences not only for the technical sessions and the exhibition, but most importantly to meet and talk to others. As I recently pointed out, it is very inspiring to meet others and get to (more...)

Get out and talk to others

Coming back from APEX connect last week in Berlin, I realized once again how important events like this are.

Having skipped some conferences in the past 6 months due to our second sons arrival, APEX connect was a welcome change to dirty diapers ;-)

Anyway, I particular want to point out the importance of getting out of your usual environment (office) and meet other people working with similar technologies. Everyone you meet at events like (more...)

Question: Table names singular or plural?

Yesterday I put a question on twitter, to find out what others prefer: table names using singular or plural form. I expected one or two replies, not an avalanche :-)

As expected there were all kind of replies going either singular or plural. Some (more...)

APEX Frühstück Meetup Wien

Kurz notiert: am 4.11.2016 gibts ein APEX Frühstücks-Meetup mit vielen neuen Infos zu Oracle APEX.

Bitte hier anmelden: https://www.meetup.com/orclapex-Vienna/events/234665282/

OTN Appreciation Day : APEX Metadata Repository

Thanks Tim for coming up with that great idea.

My favorite feature is the Oracle APEX Metadata Repository.

As you are probably aware of, APEX applications aren’t compiled. They are stored as metadata in a relational data model. Of course we aren’t allowed to access the tables in the APEX schema directly (e.g. APEX_050000), but APEX provides a bunch of dictionary views to read everything you want to know.

You can find all views (more...)

Remove the screen reader link from your APEX Footer without breaking the UT Subscription

That’s a looong title, right?

I got a questions like that in the past year on a regular basis: “do you know how to remove the Set Screen Reader Mode On link from an APEX application footer without breaking the universal theme subscription?”

sample_database_applicationAnd I always had to say “never tried, but there must be a way”. Today was finally the day when I wanted to get rid of the message from one of (more...)

What’s new in Oracle APEX 5.0.4

As announced on Twitter, Oracle APEX Patchset 5.0.4 is released. Download the full release or get the Patch 23192730 from support.oracle.com.

What’s new/changed, besides the obvious listed in the Patch Release notes?

APEX Views

  • got an improved security check. They now look for read privilege on the apex-admin-role instead of full admin privileges.
  • APEX_DEBUG_MESSAGES finally lists the Call Stack where a message was written (level 9 debug, only)
  • new View APEX_INSTANCE_PARAMETERS

APEX (more...)

New APEX training in Vienna – APEX Debugging and Performance

Just a quick note: I’ll be holding a 1-day APEX training class on April 21st in Vienna, Austria.

In this training I’ll teach you how to debug your APEX applications, how to find problems and bugs and how to speed up your application.

Interested? Go here and sign up: http://www.aoug.at/Event/413

How to update a custom public theme in Oracle APEX

In the last post I showed how you can upload a custom theme to the instance repository so that all your developers can choose that theme within the create application wizard. And more importantly, subscribe that theme from the theme repository.

Now the next question is how to update that public theme so that all applications can inherit the changes.

My first attempt was to simply go to Instance Administration – Manage Instance – Public (more...)

Creating a custom public workspace theme

The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.

With that new theme most, if not all, older themes are obsolete.

That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.

Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)