Pls help for the doubt

ravi.sadani19 · #1 (**permalink**) 04-12-2007

Hi All,

I have to queries :
1. Why we always put #!/bin/ksh on the top of any shell script
2. How we can connect to Oracle SQL prompt from UNIX shell and what all parametres need to be set for that.

Thanks,
Ravi

rahulrathod · #2 (**permalink**) 04-12-2007

For the 1st question What does "#! /usr/bin/ksh" mean?

and for the 2nd try the following snippet.

Code:

sqlplus -silent ${DBUSER}/${DBPASS}@${ORACLE_SID} << ENDSQL
      set feedback off serveroutput on size 5000
      execute pkg_1.pr_1;
      commit;
      Delete from table1;
      commit;
ENDSQL

ravi.sadani19 · #3 (**permalink**) 04-12-2007

Thanks Rahul.
but i want to know that where the parameters for connecting are set.
Like {DBUSER}/${DBPASS}@${ORACLE_SID}

blowtorch · #4 (**permalink**) 04-12-2007

They are not 'set' as such anywhere. You have to manually export them into the environment. Such as:

Code:

export ORACLE_SID=<whatever_the_sid_is>
export ORACLE_HOME=<whatever_the_home_is>
export PATH=$ORACLE_HOME/bin:$PATH
sqlplus....

ravi.sadani19 · #5 (**permalink**) 04-12-2007

Thanks a lot

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
doubt in awk	jisha	Shell Programming and Scripting	4	04-16-2008 04:02 AM
AWK doubt	Rafael.Buria	Shell Programming and Scripting	2	02-06-2008 11:00 AM
doubt about awk	soujanya_srk	UNIX for Dummies Questions & Answers	2	01-10-2008 05:26 PM
awk doubt..	esham	Shell Programming and Scripting	11	10-11-2007 02:24 AM
ftp doubt	ranj@chn	Shell Programming and Scripting	0	01-04-2006 08:47 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