A developer takes out "insurance" when they write code to "make sure" or "just in case". This can be unnecessary & unproductive. See examples.
Read morePL/SQL packages are great! But there is one package feature you shouldn’t use: Initialization. Your first inclination should be to avoid it. Steven Feuerstein explains why.
Read moreThe Automatic Time Zone setting in APEX presents some significant challenges. Anton adresses the issues by bypassing this feature with an implementation of his own.
Read moreSteven discusses when it makes sense to choose a string-indexed associative array (one of the three types of PL/SQL collections)
Read moreLazy can be a good developer characteristic or a terrible one depending on how and when applied. Steven and Marlyn look at examples of each.
Read moreWatch out for always using an IF statement, consider using a CASE expression, in SQL as well as PL/SQL, and then look for opportunities to use CASE statements as well.
Read moreIn this blog post, we are going to explore how a 3rd party library can be added to Oracle APEX. In particular – we are going to look at how to integrate Google Material components to Oracle APEX. I’m going to assume you have an intermediate knowledge of APEX...
Read moreDespite the troubled times that we are living in these days because of the COVID-19 pandemic, lots of good and valuable news is coming to us from OATUG Forum Online, (which replaces the Collaborate 20 conference), as well as from announcements by the Oracle APEX team. Certification of Oracle...
Read more