Report mail alert
#!/bin/bash # Define database credentials DB_USER="your_user" DB_PASS="your_password" DB_SID="your_db" # Email Configuration EMAIL_TO="recipient@example.com" EMAIL_SUBJECT="Daily Oracle Report - $(date +%Y-%m-%d)" REPORT_FILE="report_$(date +%Y%m%d).txt" # Function to execute SQL query and format output run_query() { SECTION_TITLE="$1" QUERY="$2" echo "=============================================" >> "$REPORT_FILE" echo "SECTION: $SECTION_TITLE" >> "$REPORT_FILE" echo "=============================================" >> "$REPORT_FILE" sqlplus -s "$DB_USER/$DB_PASS@$DB_SID" <<EOF >> "$REPORT_FILE" SET PAGESIZE 500 LINESIZE 150 VERIFY OFF HEADING ON FEEDBACK OFF TRIMSPOOL ON $QUERY EOF echo "" >> "$REPORT_FILE" } # Clear old report file > "...