Search Results

Hi ,

I want to write a Unix script which can send an automatic email to the group when my job is completed.I'm trying the following

Mail -s "test" <groupname> << EOD
>Completed
>EOD

With...

Hi Abhilash,

you should use the following query in ur script to delete the records other than upper case

select * from employee where city not in ucase(city)
delete from employee where city...

Hi Gauravah,

U should try the following to display only output without dispalying oracle messages

set heading off
set lines 500
set trimspool on
set trimout on
set echo off
set pagesize 0...

Thanks Jim for your reply.I understood now.

I'm trying to connect to oracle with the following code in the script:

checksqlerror{
if [$1 eq 0]
echo $1
exit
fi
}
$SQLPLUS username/password@schemaname
checksqlerror "failed to connect...