Shell Programming and Scripting

Hi,

I have a shell script where I log on to sqlplus like this

log()
{
sqlplus -s scott/tiger <<!
select count(*) from EMP;
!
}

log

Here I have hardcoded/used the username : scott and password : tiger directly to log on to SQLPLUS. If i have my log in information in my profile file then how can I make use of it, instead of harcoding values in the script.

Thanks in advance

Let usernm and pwd be variables defined in the .profile

sqlscpt.sh

Code:

log()
{
sqlplus -s $usernm/$pwd <<!
select count(*) from EMP;
!
}

log

Run the script like this

Code:

. ./sqlscpt.sh

I have a little writeup on running SqlPlus commands and PL/SQL procedures from a shell script. Take a look at it. Its located at http://timarcher.com/?q=node/48

It demonstrates a simple way to do it under Oracle and RedHat Linux. Furthermore I show you how to get the return codes from the sql plus execution into your unix script so that you can jump to an appropriate path of execution in your shell script.