The same way as you do perl: external library.... > -----Original Message----- > From: Jesse, Rich [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 4:44 PM > To: Multiple recipients of list ORACLE-L > Subject: 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 > [EMAIL PROTECTED] 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.htm > l#Others > http://www.linuxjournal.com/article.php?sid=3882 > http://www.linuxworld.com/linuxworld/expo/lw-python.html > To know Python is to love Python. > Language redactionist, minimalist, extremist, pacifist... > > > -----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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen 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).
