30Jun
By: Steven Feuerstein On: June 30, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this episode, Steven dives into the challenge of handling exceptions that occur when you run a forall statement.

Read more
23Jun
By: Steven Feuerstein On: June 23, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Collections are PL/SQL's version of arrays. Steven talks about ways you can, should, shouldn't iterate through the contents of collections.

Read more
14Jun
By: Steven Feuerstein On: June 14, 2021 In: APEX Developer Solutions, Feuertips Comments: 3

In this blog, Steven proposes a refactoring exercise. Look at the code. What changes does it need? Discuss it with him on Feuertips June 16.

Read more
09Jun
By: Steven Feuerstein On: June 9, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this blog for episode 12 of Feuertips, Steve shows us how to suppress row-level errors in Oracle Database.

Read more
02Jun
By: Steven Feuerstein On: June 2, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

Naming conventions are key to writing high-quality code. Steven explores what motivates conventions to clarify what works best for us and why.

Read more
26May
By: Steven Feuerstein On: May 26, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

In this episode: to manipulate in-program data in set-kinda ways, use nested tables. They have cool, set-oriented features.

Read more
10May
By: Steven Feuerstein On: May 10, 2021 In: APEX Developer Solutions, Feuertips Comments: 0

The WITH keyword lets us use modular design with SQL and helps avoid redundant logic in SQL statements. Learn more in this Feuertips episoide

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