0

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

3
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by scripter.online
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.