Parsing CSV string

Parsing a CSV string is something very trivial, but often many people choose an inefficient approach usually based on this pseudo-code: loop if the CSV list is empty then break copy the first value to some variable remove the first value from the CSV list...
Continue reading »

How to implement sleeping

There are few approaches how to implement sleeping in PL/SQL: DBMS_LOCK.SLEEP procedure (precision: hundredths of a second) DBMS_BACKUP_RESTORE.SLEEP (precision: seconds) java.lang.Thread.sleep method mapped by PL/SQL procedure (precision: milliseconds) Autonomous transaction (In fact, this Tanel’s post inspired me to write this) (precision: seconds) Of course, I...
Continue reading »