As a developer, most of the time you have to testing on your script output.
Some how, you also need to debug into the script & checking on each variable value.
In Oracle procedure, if you doesn’t having any debugging tools like sql developer. It is very difficult to trace your procedure whether is working properly or not.
For me, I will using the DBMS_OUTPUT.PUTLINE command & sqlplus into the Oracle for the testing.
Below is the example. read more »














