What is New Line Character in Oracle? Sometimes, we need to make several lines for each row. For example, we'd like to compose some dialogs… Read More »How to Add New Line for Each Row
Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle
Here I introduce a sample of PL/SQL code to monitor the blocking sessions every N minutes and output in a formatted report. First of all,… Read More »How to Identify Blocking Sessions