For a customer I was required to extract and report data from an Oracle database
Ofcourse I want to automate this task to the full extent. 155 more words
Tags » Oracle
SQL> connect sys/password as sysdba Connected. SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql Package created. Synonym created. SQL> @$ORACLE_HOME /rdbms/admin/prvtmail.plb Package body created. No errors.
SQL> alter system set smtp_out_server = '<ip-address:port' scope=Both; System altered.120 more words