Monthly Archives: March 2011

Win 7 Security 2011

Ok so my machine got infected by a Trojan and Win 7 Security 2011 hijacked all programs. It was a Friday eve and I just wanted to watch a light movie after deployment day @ work. But Win 7 Security … Continue reading

Rate this:

Posted in Computer | Tagged , , , , | Leave a comment

Oracle Mail

Hello Readers, This post would focus on sending mails from Oracle. Of all the nice packages, utl_mail package can be used directly to send emails from Oracle objects.  By default, sending mails is disabled from Oracle due to security reasons. … Continue reading

Rate this:

Posted in Oracle | Tagged , , , | Leave a comment

Oracle Scheduler

Readers, Schedulers are always a yes yes for a Software Engineer. You can do scheduling in Java via Quartz, Unix via Cron, Windows via Windows Scheduler UI (not so reliable though). Oracle too allows to schedule objects via dbms_scheduler package. Ok, … Continue reading

Rate this:

Posted in Oracle | Tagged , | 1 Comment

Oracle block execution time

Hello Readers, Long time since my last post. Got busy @ work & cricket wc. Ever wondered to find the execution time of your cool Oracle proc/function/block. dbms_utility package allows to do this job in an elegant way. Example below: Thanks, … Continue reading

Rate this:

Posted in Oracle | Tagged , , | Leave a comment