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
sri4shell
0
Newbie Poster
Recommended Answers
Jump to PostSure! 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 …
All 3 Replies
JeoSaurus
32
Posting Whiz in Training
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
JeoSaurus
32
Posting Whiz in Training
Here's a link that might get you started:
http://www.orafaq.com/wiki/SQL*Plus_FAQ#What_is_SQL.2APlus_and_where_does_it_come_from.3F
Experiment with care!
scripter.online
0
Newbie Poster
step by step procedure
to Connect to oracle database from unix shell script
http://www.scripterworld.com/2009/08/connecting-to-oracle-database-from-unix.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.