| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Programming languages that make DBA's lives easier
Cool! How'd you get Python to run from a DBMS_JOB?
:D
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Tuesday, February 18, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L
3, 4, 5, 6 can be replaced with Python or Jython with wx_Python for added GUI-ness. :-)
http://www.networkcomputing.com/unixworld/tutorial/005/005.html#Others http://www.linuxjournal.com/article.php?sid=3882 http://www.linuxworld.com/linuxworld/expo/lw-python.htmlTo know Python is to love Python.
-----Original Message-----
Sent: Tuesday, February 18, 2003 12:38 PM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.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). Received on Tue Feb 18 2003 - 15:43:46 CST
 |
 |