Today, I want to talk about some useful information, tricks and common mistakes about PL/SQL. Even you are a junior or an advanced PL/SQL developer, I admire you will find them useful. Let's start.
When it comes to analyzing "pure" SQL code, most Oracle user know how to do it - with their prefered tools such as DBMS_XPLAIN or SQL Developer, SQL traces, AWRs, SQL Access Advisor etc. But how do ...