Archives
An episode all about triggers. They can be amazing, but they can be abused and lead to unexpected behaviors. Steven drills down.
Read more
When should you commit changes in your PL/SQL code? When does PL/SQL itself perform commits for you on your behalf? Find out in this episode of Feuertips.
Read more
Cursor for loop is an example of #plsql's tight integration with #SQL, but it also presents opportunities for "bad lazy" coding. Steven explains
Read more
Steven shares some tips on how to write declarations in PL/SQL subprograms or packages for maximum readability and maintainability
Read more
Following up on the previous Feuertip on dynamic SQL, Steven is joined by Anton Nielsen to explore how to use dbms_assert to reduce the chance of SQL injection and otherwise bullet-proof your code.
Read more
Don't have all the info you need at compile time to write a complete SQL statement? Go dynamic. Steven explains.
Read more
Learn how to generate a conditional compilation package so that your code uses the latest features in APEX APIs - and your own products!
Read more
Toon Koppelaars of Oracle's Real World Performance Team discusses the ORA-04068 error with Steven, and what to do if you get it.
Read more
Steven introduces invoker rights (AUTHID). Learn some essential differences between definer rights and invoker rights in the Oracle Database.
Read more