A list of languages doesn’t do much good unless you know why they are needed
and how important the language is to your Oracle implementation:
1) PL/SQL.
Vital! Needed in order to create database triggers, functions,
procedures, and packages. Know it and know how to write it well. This
could be the single most important performance killer for systems.
2) Some Unix shell. I prefer Korn.
Vital if you are maintaining Oracle DBs on a Unix/Linux platform to
be able to debug Oracle problems by knowing where important Oracle files are
located and how to examine and manipulate them. Also needed if you want to
use Oracle Internet Directory on Windohs, via the CygWin environment. If
you support Oracle on OpenVMS, extensive knowledge of DCL, the shell on
OpenVMS, is a definite plus.
3) Perl.
Very important. It’s cross-platform, can do many OS functions with
greater control over Korn/Bash/Csh (IMHO), and has a huge development base.
I use it for DB functions like some hot backup-and-startup over multiple
nodes as well as some external OS file manipulation (Oracle log and trace
files) that was just too difficult to do in Korn from the OS and not
applicable to do from Java in the DB. There’s also the Perl for Oracle DBAs
book, which is very popular among folks on this list. (Sorry, Jared! It’s
next on my Book List, though! Tax refund soon!)
4) Java.
Not critical for us yet, but we are rolling out a few Java apps in
one of our DBs. It’s needed for us because it’ll give us a way to replace
some icky VB apps whose sole purpose is to e-mail from an app. I’ve also
setup some PL/SQL procedures that allow a developer to enable 10046 tracing,
turn it off, and call Java to tkprof and copy the protected trace file to
their directory. I still don’t know Java much, but have been able to glean
enough to pull this off.
5) Tcl.
We don’t need it, but it would be helpful if you want to roll your
own OEM events, at least up until now. Not sure what the upcoming OEM
version uses on the server side.
6) Tk.
Cool if you want to roll your own GUI apps in Perl or Tcl. :)
That’s my $.02. Enjoy! :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Tuesday, February 18, 2003 10:56 AM
To: Multiple recipients of list ORACLE-L
On top of learning Oracle, which programming languages would also benefit
some1 learning Oracle? Perl? Java? How would these languages be used?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
