05May
By: Steven Feuerstein On: May 5, 2021 In: APEX Developer Solutions, Feuertips Comments: 2

If you can't always perform automated regression testing, you can build a simple test harness and, as much as possible, make sure your procedures are broken up into units that can be easily tested. See Steven's example.

Read more
28Apr
By: Steven Feuerstein On: April 28, 2021 In: APEX Developer Solutions, Feuertips Comments: 2

The execution of non-query DML can cause all sorts of SQL errors. Steven lays out guidelines in DML Handling code.

Read more
21Apr
By: Steven Feuerstein On: April 21, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

What should be in your exception handling section? Things pertaining to exception handling. What shouldn't? Application code. Learn more.

Read more
16Apr
By: Michelle Skamene On: April 16, 2021 In: APEX Developer Solutions Comments: 1

Oracle APEX sometimes seems endlessly extensible. If you're missing something from the vast array of native, declarative components, you're likely to find it in the form of an Oracle APEX Plug-in. In this post, we curate a list of favourite plugins, as per some of Insum's consultants.

Read more
14Apr
By: Steven Feuerstein On: April 14, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

A developer takes out "insurance" when they write code to "make sure" or "just in case". This can be unnecessary & unproductive. See examples.

Read more
07Apr
By: Steven Feuerstein On: April 7, 2021 In: APEX Developer Solutions, Feuertips Comments: 1

PL/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 more
26Mar
By: Anton Nielsen On: March 26, 2021 In: APEX Developer Solutions, Instant Tips Comments: 0

The 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 more
24Mar
By: Steven Feuerstein On: March 24, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Steven discusses when it makes sense to choose a string-indexed associative array (one of the three types of PL/SQL collections)

Read more
15Mar
By: Steven Feuerstein On: March 15, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Lazy 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 more
09Mar
By: Michelle Skamene On: March 9, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Watch 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 more
X