944,149 Members | Top Members by Rank

Software Development > Shell Scripting > connect to oracle retrieve data and work around the data through shell script
Ad:
Permalink
Dec 28th, 2008
0

connect to oracle retrieve data and work around the data through shell script

Expand Post »
Can any one please let me know how to connect to oracle retrieve data and work around the data through shell script. for example i have to get salary of 5 employees and add 500 to them and print them.
thanks a ton in advance.
Sriram
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sri4shell is offline Offline
1 posts
since Dec 2008
Permalink
Dec 30th, 2008
0

Re: connect to oracle retrieve data and work around the data through shell script

Sure! I don't have any examples in front of me, but the Oracle command line client is sqlplus. There are others, but I think sqlplus is the one that ships with Oracle. You should be able to script something that uses sqlplus to get what you need from the database and then manipulate it with bash.

Can you add 500 to my salary while you're at it?

Thx!
-G
Reputation Points: 46
Solved Threads: 28
Junior Poster
Gromit is offline Offline
183 posts
since Sep 2008
Permalink
Dec 30th, 2008
0

Re: connect to oracle retrieve data and work around the data through shell script

Here's a link that might get you started:

http://www.orafaq.com/wiki/SQL*Plus_...t_come_from.3F

Experiment with care!
Reputation Points: 46
Solved Threads: 28
Junior Poster
Gromit is offline Offline
183 posts
since Sep 2008
Permalink
Nov 4th, 2009
0
Re: connect to oracle retrieve data and work around the data through shell script
step by step procedure
to Connect to oracle database from unix shell script

http://www.scripterworld.com/2009/08...from-unix.html
Reputation Points: 10
Solved Threads: 0
Newbie Poster
scripter.online is offline Offline
1 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Shell Scripting Forum Timeline: Uix Script Help Need
Next Thread in Shell Scripting Forum Timeline: how to enter for the prompt?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC