I posted earlier about sending html mail. Here an example on how to send -fake- excel per mail echo “select * from emp;”| sqlplus -M “HTML ON” -s scott/tiger| uuencode emp.xls| mail firstname.lastname@example.org May this be of some help to my readers !
Your business partner wants to receive some daily mail with an sql query output in it. It does not need to be ultra-fancy, but some colors and titles would not hurt. Here is the report in SQL: select dname, sum(sal) from emp join dept using (deptno) group by rollup(dname); Ok, let’s do the report within […]
I wrote about tracking ddl changes with a trigger there : track ddl changes Another option is to use auditing. A new and cool alternative is to use enable_ddl_logging (11gR2). This will track all ddl’s in the alert log ALTER SYSTEM SET enable_ddl_logging=TRUE Then later you issue create table t(x number) and you see in […]