Search Results

Thanks for your time! I have modified my script as follows and the excel attached to the email is now coming up in the correct form...

#!/bin/ksh
export ORACLE_HOME=/oracle/product/current...

Actually I need to use a .sh file only. And csv file is good enough for me. But even in csv the data is not coming up properly. Can you please suggest and solutions for this ?

Even in .csv file i am facing the problem. Can u please tell me how to resolve it ?

Hi,

The following in the code which I am using :

#!/bin/ksh
export ORACLE_HOME=/oracle/product/current
export PATH=$PATH:$ORACLE_HOME/bin

sqlplus -s schema/pswd@db <<EOF
set pagesize 200...

Hi,

I have a shell script which send email with an attachment in the form of an email. However, the when I open the attachment, all the data comes in one column. How do I format the data in the...