Monthly Archives: 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 !’ ,'[^ ]+’, 1, 3) from dual ; Output: REGEX REGEX R —– —– –

Posted in Scripts