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

Recommended Answers

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 …

Jump to Post

All 3 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.