How To Extract,Using Bash/Unix/Linux Shell Scripting, The Oracle Data Like Excel Report And Send As Email Attachment?

Posted by Jiltin     Tags: , , , , , , 1 December, 2008    7,141 views    (0) Comment

This script provides an sample, and then the practical example to connect to oracle database, extract data like excel sheet and attach it with an email list. First connecting is done with “sqlplus -s $FCP_LOGIN” in silent mode.Then EOF marks the begining of sql statement and another EOF marks end of it.The chr(9) provides the tab required to make this as excel sheet.In fact, it creates a csv file with tab delimited entry.Since the filename Read Full Article (Click here)...

Categories : 11i Scripts, Scripts Oracle, Scripts Unix, Web & Scripts Tags : , , , , , ,