Archives
A rundown of Insum's presentations at Kscope21. This year we're proud to be Bronze Sponsors and APEX track sponsors.
Read more
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
In this blog for episode 12 of Feuertips, Steve shows us how to suppress row-level errors in Oracle Database.
Read more
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
In this episode: to manipulate in-program data in set-kinda ways, use nested tables. They have cool, set-oriented features.
Read more
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
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
The execution of non-query DML can cause all sorts of SQL errors. Steven lays out guidelines in DML Handling code.
Read more
What should be in your exception handling section? Things pertaining to exception handling. What shouldn't? Application code. Learn more.
Read more
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