Search Results

try out giving $sqlerr in double quotes like

if [ -n "$sqlerr" ]


Please let me know whether it works or not as right now i dont have access to unix server.;)

Are u goin to make selection as only 1,2 or 3 or is it full line..
Suppose that u have to make selection as 1) do this then do the following :


case $answer in
"1\) do this")...

Hi Navjot,

I am also new to unix ;). But i have tried to this code and its working fine for checking the 3rd character of string to be 'c' :


i=`echo "abc123" | cut -c3`
echo $i

if [...

Hi Revo,

No. It is nothing do with how the oracle assigns the value to the variable. The thing which i got to learn is that you cannot pass a variable directly into the subject of the mail. On...

Hi all,

I got the solution to my question. Sometimes we think too complex solutions for the simple questions.:p:b:
The subject just required to be assigned with echo command to get it displayed...

Alex,

For your kind information i have already tried your method i.e. ">${week_end_dt}<" to include in the subject. but its not working. I dont know why. probably it might be working for u. For...

please reply asap!!!!

Hi all,

The value of week_end_date is coming properly. There is no problem in echoing that. The problem is that value is not displayed in the subject of the mail. On the contrary if I specify...

Hi, i am again sending u the code and the output of that code.

week_end_dt=`sqlplus -s rsamart@martdev.world/rsamart<<EOF
SET FEED OFF;
SET TIMING OFF;
SET HEADING OFF;
SET PAGESIZE 500;
SET...

HI,

Whatever you said I already tried and its working fine for me too.

But the problem is that we are fetching week_end_dt from oracle. So it is assigning the oracle format to the variable. I...

hi,
i want to pass a unix variable as the subject of the mail alongwith a string. My part of code is as below..

week_end_dt=`sqlplus -s rsamart@martdev.world/rsamart<<EOF
SET FEED OFF;
SET...

hi,
i want to pass a unix variable as the subject of the mail alongwith a string. My part of code is as below..

week_end_dt=`sqlplus -s rsamart@martdev.world/rsamart<<EOF
SET FEED OFF;
SET...