Tag SQL

Generate Excel and PDF in Oracle and Send Report by Email

First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…

Oracle vs. Microsoft SQL Server: Why Oracle wins

Original Article : http://searchoracle.techtarget.com/tip/Oracle-vs-SQL-Server-Why-Oracle-wins A brief comparison between Oracle and SQL Server. Oracle comes out leaps and bound ahead in this…