Improve company productivity with a Business Account.Sign Up
sqlplus username/password@prod_database > /tmp/junk.log << EOF
select case when count(*) = 1 then 'ERROR' end from dual;
ERROR_COUNT=`grep -c ERROR /tmp/junk.log`
if [ "$ERROR_COUNT" -gt 1 ]; then
mailx -s "Something bad happened in production" firstname.lastname@example.org
Open in new window
sqlplus devuser/devpassword@devdatabase << EOF
exec utl_mail ...
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.