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 [email protected] May this be of some help to my readers !
Month: April 2011
Send html report per email from sqlplus
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 […]
Over one million books sold!
Advertisment found on http://www.firefoxsupport.net/software-download/advanced-oracle-sql-programming-the-expert-guide-to-writing-complex-queries.html
track ddl change (part 2)
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 […]