Unix : Shell Script

To Connect to Oracle and execute a Script
-----------------------------------------
#!/usr/bin/sh

sqlplus -S gemsit_etl@dwdev/gemsit_etl <>output.val


To use While Loop
------------------
while [$val -lt $val2]
do

done

To check a File
---------------
if [ -s $file_name]
then

else

fi

To add numbers
--------------
some_var = `expr $val + 1`

To Send mail
--------------
mailx -s "${mail_subject}" `cat ${MAIL_ID_LIST}` < /tmp/mail.txt