Re: Programming languages that make DBA's lives easier

Les Ayudo wrote:
> On top of learning Oracle, which programming languages would also
> benefit some1 learning Oracle? Perl? Java? How would these languages
> be used?

In (my) order of importance:

1. SQL and PL/SQL
2. Whatever shell scripting language your environment supports (sh,ksh,csh,bash on Unix, typically, and the Windows Batch language if your database is on Windows)
3. Whatever language the applications you're supporting are written in.
4. Perl.

Learning the local "default" scripting language for your environment (ksh or Windows Batch) should be extermely high on your list as you can't always be certain that Perl (or whatever your favorite happens to be) will be installed on a given system.

If you're maintaining an Oracle Apps Environment, C would be a good one to learn (or at least familiarize yourself with) as even a basic knowledge of C can help you to troubleshoot the compile/link process used so commonly with the Applications.

Also, if you don't know it and you work on a unix environment, I suggest you learn the basics of the vi editor. (It's also basically the only one that you can be certain to have). Emacs may be wonderful, but vi is _always_ there...

• James

Nascent Systems, Inc.
Senior Technical Consultant

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: James J. Morrow
  INET: jmorrow_at_warthog.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).