Month: July 2011

Oracle Developer Suite 10g windows software download media

Oracle Developer Suite 10g for Windows (forms developer) is not easy to obtain now, out of support by Oracle for a long time, but that version is still in use out there. So I have zipped both installation CDs

Posted in Uncategorized

Cron fix for ulimit: max user processes: cannot modify limit:operation not permitted

Werner Puschitz has details of how to use ulimit and limits.conf to change maximum processes and open file descriptors. But for processes running from cron, I found I had to additionally make the below changes (this is on old version:

Posted in Uncategorized

Split space delimited string with regexp SQL

Split up a delimited string with: SELECT REGEXP_SUBSTR ( ‘Hello world !’ , ‘[^ ]+’ , 1 , 1 ) , REGEXP_SUBSTR ( ‘Hello world !’ , ‘[^ ]+’ , 1 , 2 ) , REGEXP_SUBSTR ( ‘Hello world !’

Posted in Scripts