Shell scripting SQL book 1

[handle789]

Hi,

I am looking for books that have plenty of examples on using unix shell scripting with embedded SQL statements inside the shell scripts. I haven't yet found a good book either on amazon.com or through google search. I already have books on either shell scripting or on SQL as separate topics. What I need is a book that has good examples on using both of them together. For example, a shell script that inserts a thousand rows of data into an oracle table. Thanks for your pointers.

 

[KenCunningham]

I doubt if such a specific book exists (but am quite prepared to be shot down!). Generally, such shell scripts are used to 'set the scene', ie setting things like environment variables ($ORACLE_HOME, $ORACLE_SID, $PATH etc) so that the SQL script runs successfully againsts the correct instance and 'knows' where to find things such as sqlplus. This is particularly relevant to scipts run via cron, where the vanilla environment is minimal to say the least.

I have examples at work which I'll post on Monday if no-one else chips in beforehand. However, hope this helps in the first place.

I want to be good, is that not enough?

 

[PHV]

Have a look here:
faq80-2224

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[KenCunningham]

That, PHV, is excellent - thanks for pointing it out.

I want to be good, is that not enough?

 

[handle789]

Thank you for the FAQ. I found a few short articles below.

http://www.oracle.com/technology/pub/articles/saternos_scripting.html

http://www.experts-exchange.com/Database/Oracle/Q_22806863.html

Below is the URL of an Oracle shell scripting book. But most of the book talks about stuffs that you can easily find in other beginner's unix shell scripting books. For example, from the table of contents, chapters 1-5, 7, 9, 10, 11, 16, and most of chapter 8 are in most unix shell scripting books (that's 2/3 of the book). The remaining chapters are more related to a DBA's basic tasks, but not what an SQL programmer needs. The book doesn't contain many pages (and also talks about Linux?). So it may not be worth the cost.

http://www.rampant-books.com/book_2007_1_shell_scripting.htm