Logging into oracle or SQL from shell script

manirsendhil · #1 (**permalink**) 02-23-2007

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

anbu23 · #2 (**permalink**) 02-23-2007

Let usernm and pwd be variables defined in the .profile

sqlscpt.sh

Code:

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

log

timarcher52 · #3 (**permalink**) 04-10-2007

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.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Logging OWB mapping execution in Shell script	npn	Shell Programming and Scripting	1	11-16-2006 09:25 AM
Have a script running even with the shell logging out	435 Gavea	Shell Programming and Scripting	4	09-20-2005 05:20 PM
logging in Shell script	laila63	Shell Programming and Scripting	3	07-16-2004 06:50 PM
shell script error logging	niamh	UNIX for Dummies Questions & Answers	1	04-05-2004 12:17 PM
security permission logging onto Oracle database	ctcuser	UNIX for Dummies Questions & Answers	1	03-23-2004 11:14 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by