[SOLVED] sqlplus not working within if condition

sysmicuser · 04-27-2013, 09:10 PM

Guys,

I am not sure what is the problem but somehow this is not working

Code:

#!/bin/sh
export TNS_ADMIN=/path to tnsnames.ora
export password=my_password;
export day="sunday"
        if [[ day = 'sunday' ]];  then
        sqlplus username/${password}@orcl << EOF
        set echo on
        set serveroutput on
        insert into table_temp(col_date,file_name,status) values(sysdate,'XYS','success');
        commit;
         exit;
        EOF
        else
        echo "NO"
		fi

kooru · 04-28-2013, 01:45 AM

Hi,

a right way is:

Code:

..
if [ "$day" == "sunday" ]; then
..

http://tldp.org/LDP/abs/html/comparison-ops.html

chrism01 · 04-28-2013, 06:53 AM

If you use double [[ ]] http://tldp.org/LDP/abs/html/testcon...ml#DBLBRACKETS, you don't need to quote the values there.
Incidentally, no need to export stuff either, that's only if you want the vars to appear in a subshell.

sysmicuser · 05-03-2013, 06:10 AM

@chrism01.

I am inexperienced person, may you enlighten me with your rich shell scripting experience.

So if i use [[ ]] then i don't have to use " inside those brackets? so we need to export the variable only if I want to use them in subshell? so I don't want to export how can I initialise the variable? Please explain thanks.

chrism01 · 05-03-2013, 08:46 AM

Try this for 'export' http://stackoverflow.com/questions/1...without-export

sysmicuser · 05-03-2013, 09:49 AM

@chrism01.

I have seen people using SET, DEFINE or LET keywords used to define variables, can you shed some light there as well please ?

Many Thanks in advance !