Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Pls help for the doubt

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pls help for the doubt
# 1  
Old 04-12-2007
Pls help for the doubt
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
# 2  
Old 04-12-2007
For the 1st question https://www.unix.com/showthread.php?t=7077

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

# 3  
Old 04-12-2007
Thanks Rahul.
but i want to know that where the parameters for connecting are set.
Like {DBUSER}/${DBPASS}@${ORACLE_SID}
# 4  
Old 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....

# 5  
Old 04-12-2007
Thanks a lot
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Help pls

How to find the ten most common words in a file (1 Reply)
Discussion started by: jass
1 Replies

2. Solaris

Doubt in zone configuration pls help

Hi I am new to solaris I am running solaris from sun virtual box I am trying to create a zone but it is giving some error... First i configured my zone zonename: test zonepath: /rpool/zones/test brand: ipkg autoboot: true bootargs: pool: limitpriv: scheduling-class: ip-type:... (1 Reply)
Discussion started by: vijaysachin
1 Replies

3. UNIX for Dummies Questions & Answers

HELP PLs

I have this code: #!/bin/sh awk 'BEGIN NR == 2 repl = "PHI" $4 = repl print $0 'dryloop.txt and this code: #!/bin/sh sed -e '1s/\|$/\|COMID\|/g' -e 's/^087.*$/&PHI\|g' hl.dsldryloop > textdry.txt My code won't work. I want to change the COMID of lines starting with 087 . this is my... (15 Replies)
Discussion started by: arkhei
15 Replies

4. Shell Programming and Scripting

Pls Pls do help me

When i run this command, everything is ok. The file can be email and attached but soon after i download the file, the file cant be read. It's seem corrupted. Totally cant be read although i'm using context or wordfile. Original file generated at ek_bkup/alert/tbspace_datafile.log is OK..... ... (7 Replies)
Discussion started by: adzuanamir
7 Replies

5. Shell Programming and Scripting

Pls Help

Hi Folks, I am new to this forum. and I just started learning shell scripting. I have a file called energy.out which looks like: -218213.3729 -224215.0059 -221509.3651 -221094.2627 -220660.3223 -222630.2339 -218697.8693 Now I want to calculate the average of energies and then average... (3 Replies)
Discussion started by: pkar
3 Replies

6. Shell Programming and Scripting

pls help

I have a list of variables: ss1, ss5, ss6, ss8, st2 etc. (these values are not fixed, configurable). Now, I have assigned ss5=”test”. And I want to search in the list for the string “test” to know which variable is having the value “test”. Can u pls tell me how to do this? (10 Replies)
Discussion started by: kanchan_cp
10 Replies

7. UNIX for Dummies Questions & Answers

Help pls!

Hi... Why should I press F1 to start windows?! I have Xp in my computer... thx 4 help Cano (1 Reply)
Discussion started by: Cano
1 Replies

8. UNIX for Dummies Questions & Answers

Pls Help

Hi every one I have got very very bad Email, My question is: How can I get all information about that f*** Email, I do mean IP,reall name, Adress, user name, password etc... I wonder if there is any program or website that I can see that email, help me please When I used windows Xp(old... (2 Replies)
Discussion started by: Cano
2 Replies

9. UNIX for Dummies Questions & Answers

Need help pls

Hi, I'm a newbie. I need help on my first assignment in UNIX. 1. How do I determine the number of non-empty directories? I was told to create a variable ARCHIVE, which points to the directory that contains the archive of the messages. But I'm so dumb and I don't even know how to do this. 2. In... (1 Reply)
Discussion started by: hygsg
1 Replies

10. Linux

pls help me

we hv a big enviroment networked. we use squid proxy. access allowed by src address previously. we have win2000 network with ads. my requirement is the proxy should allow domain users only for access. how can i map my windows userdatabase with squid is there any thing specific which has 2 b... (1 Reply)
Discussion started by: sriram.s
1 Replies
Login or Register to Ask a Question