Re: RE: Programming languages that make DBA's lives easier
Speak for yourself though I'd prefer to forget it. Dick Goulet "Weiss; Rick" <[EMAIL PROTECTED]> wrote on 2/21/03 6:49 am: FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? > > If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Weiss, Rick 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: 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).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier That is a great link :) -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that make DBA's lives easier For some reason http://mindprod.com/unmain.html comes to my mind. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!
RE: Programming languages that make DBA's lives easier
Does Oracle have punch cards with their logo on them? How do we order some? We need some for our Fortran applications... ; ) Pat. -Original Message- Sent: Friday, February 21, 2003 10:49 AM To: Multiple recipients of list ORACLE-L FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Weiss, Rick 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: Boivin, Patrice J 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).
RE: Programming languages that make DBA's lives easier
I think thats the goal of .NET CLI. Write in anything ... mix and match. On Fri, 21 Feb 2003, Nelson, Allan wrote: > Now this thread has gone on for a while so its time for my contribution > :-). PL/SQL is such a necessary although pedestrian language that its > not interesting. Of the scripting languages TCL, PERL, and Python all > include facilities for embedding them into other code or adding other > code to them. What we should do is mount an Open Source project to > embed Perl and TCL into Python so that we could create one large > abomination in which any syntax or facility that pleases us could be > used. Concealing your intellectual property would be simple. Write > whatever suites you at the time, no one, not even you, will be able to > figure out what you wrote after you've been away for it a week. > > Allan > > -Original Message- > Sent: Thursday, February 20, 2003 11:59 PM > To: Multiple recipients of list ORACLE-L > > > > Assembler. > > > On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > > I wonder if I can throw in a further caveat to the choices people > > would make? > > > > If you had to choose a programming language in which to write a > > program or application in which you wished to conceal your > > intellectual property, which would you use? > > > > peter > > edinburgh > > > > -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? > > > > > > > > * > > This e-mail message, and any files transmitted with it, are > > confidential and intended solely for the use of the addressee. If > > this message was not addressed to you, you have received it in error > > and any copying, distribution or other use of any part of it is > > strictly prohibited. Any views or opinions presented are solely those > > of the sender and do not necessarily represent those of the British > > Geological Survey. The security of e-mail communication cannot be > > guaranteed and the BGS accepts no liability for claims arising as a > > result of the use of this medium to transmit messages from or to the > > BGS. The BGS cannot accept any responsibility for viruses, so please > > scan all attachments.http://www.bgs.ac.uk > > * > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: quoted-printable > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > 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). > > > > __ > This email is intended solely for the person or entity to which it is addressed and > may contain confidential and/or privileged information. Copying, forwarding or > distributing this message by persons or entities other than the addressee is > prohibited. If you have received this email in error, please contact the sender > immediately and delete the material from any computer. This email may have been > monitored for policy compliance. [021216] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nelson, Allan > 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: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
Re: Programming languages that make DBA's lives easier
LOL - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 8:39 AM > > Now this thread has gone on for a while so its time for my > > contribution > > :-). PL/SQL is such a necessary although pedestrian language that its > > not interesting. Of the scripting languages TCL, PERL, and Python all > > include facilities for embedding them into other code or adding other > > code to them. What we should do is mount an Open Source project to > > embed Perl and TCL into Python so that we could create one large > > abomination in which any syntax or facility that pleases us could be > > used. Concealing your intellectual property would be simple. Write > > whatever suites you at the time, no one, not even you, will be able to > > figure out what you wrote after you've been away for it a week. > > A week? All I need is a night at the pub to make my code unreadable ... > > (mmm, maybe I shouldn't have admitted that in public :-) ) > > Ciao > Fuzzy > :-) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Grant Allen > 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: Les Ayudo 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).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier For some reason http://mindprod.com/unmain.html comes to my mind. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier > Now this thread has gone on for a while so its time for my > contribution > :-). PL/SQL is such a necessary although pedestrian language that its > not interesting. Of the scripting languages TCL, PERL, and Python all > include facilities for embedding them into other code or adding other > code to them. What we should do is mount an Open Source project to > embed Perl and TCL into Python so that we could create one large > abomination in which any syntax or facility that pleases us could be > used. Concealing your intellectual property would be simple. Write > whatever suites you at the time, no one, not even you, will be able to > figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier I much pefer Oberon or Scheme. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Weiss, Rick [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments. http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Weiss, Rick 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).
RE: Programming languages that make DBA's lives easier
Yeah Yeah Yeah ! peter . FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Weiss, Rick 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: Robson, Peter 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).
RE: Programming languages that make DBA's lives easier
> Now this thread has gone on for a while so its time for my > contribution > :-). PL/SQL is such a necessary although pedestrian language that its > not interesting. Of the scripting languages TCL, PERL, and Python all > include facilities for embedding them into other code or adding other > code to them. What we should do is mount an Open Source project to > embed Perl and TCL into Python so that we could create one large > abomination in which any syntax or facility that pleases us could be > used. Concealing your intellectual property would be simple. Write > whatever suites you at the time, no one, not even you, will be able to > figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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).
Re: Programming languages that make DBA's lives easier
Add me to the count. Though, I was making "rubles" not $$$ using it -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 9:49 AM > FORTRAN - Only one or two of us left that have even heard of it, much less > actually made $$$ using it > > Rick Weiss > > -Original Message- > Sent: Thursday, February 20, 2003 10:59 PM > To: Multiple recipients of list ORACLE-L > > > > Assembler. > > > On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > > I wonder if I can throw in a further caveat to the choices people > > would make? > > > > If you had to choose a programming language in which to write a > > program or application in which you wished to conceal your > > intellectual property, which would you use? > > > > peter > > edinburgh > > > > -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? > > > > > > > > * > > This e-mail message, and any files transmitted with it, are > > confidential and intended solely for the use of the addressee. If > > this message was not addressed to you, you have received it in error > > and any copying, distribution or other use of any part of it is > > strictly prohibited. Any views or opinions presented are solely those > > of the sender and do not necessarily represent those of the British > > Geological Survey. The security of e-mail communication cannot be > > guaranteed and the BGS accepts no liability for claims arising as a > > result of the use of this medium to transmit messages from or to the > > BGS. The BGS cannot accept any responsibility for viruses, so please > > scan all attachments.http://www.bgs.ac.uk > > * > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: quoted-printable > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > 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: Weiss, Rick > 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: Igor Neyman 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).
RE: Programming languages that make DBA's lives easier
Hey, just a minute - aren't you forgetting Dos... ? peter Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. Allan -Original Message- Sent: Thursday, February 20, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Robson, Peter 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 containi
RE: Programming languages that make DBA's lives easier
FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Weiss, Rick 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).
RE: Programming languages that make DBA's lives easier
Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. Allan -Original Message- Sent: Thursday, February 20, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people > would make? > > If you had to choose a programming language in which to write a > program or application in which you wished to conceal your > intellectual property, which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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).
Re: Programming languages that make DBA's lives easier
The Kochan and Wood is indispensible.
Jared
On Tuesday 18 February 2003 15:38, Les Ayudo wrote:
> RE: Programming languages that make DBA's lives easierI have Unix Shell
> Programming revised Edition by Kochan and Wood. Haven't had time to sit
> down and read it but it's supposed to be really good. - Original
> Message -
> From: Nick Wagner
> To: Multiple recipients of list ORACLE-L
> Sent: Tuesday, February 18, 2003 3:08 PM
> Subject: RE: Programming languages that make DBA's lives easier
>
>
> If you are just learning Korn Shell programming, I'd recommend
>
> The Korn Shell (3rd edition)
> by Anatole Olczak
>
> it's better than others I have seen, but basic... you won't get deep
> enough to make any huge programs, but it should be enough for you're Oracle
> DBA needs.
>
> -Original Message-
> From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 18, 2003 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Programming languages that make DBA's lives easier
>
>
>
> What are the good books you guys recommend for Shell Programming? I have
> old edition of UNIX shells by example (by Ellie Quigley). I need to replace
> this with some good book.
>
> Do I need to learn perl before reading PERL for DBAs? If so, what are the
> good perl books do you guys recommend?
>
> -- Babu
>
> -Original Message-
> Sent: Tuesday, February 18, 2003 1:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> I thought it might be worthwhile to say WHY I prefer ksh for most
> scripting.
>
> As one writer put it, use a language you know. I've used ksh for years,
> so that is certainly one big factor in preferring it. But, that aside, if
> you use mostly the Bourne Shell syntax and stay away from the some of the
> Korn Shell syntactical candy that doesn't do anything extra, then your
> scripts are very easy to read, and are mostly self-documenting. For me,
> that is a big advantage.
>
> If you use ksh, then you need to become reasonably proficient with a few
> of the more important utilities such as sed and awk/nawk/gawk and become
> familiar with good old regular expressions (wonderful stuff!).
>
> One area where ksh is weak is its inability to set up a two-way socket
> with a child process like sqlplus. Perl can do this (for example, by using
> IPC::Open2). With ksh, you can send to the child, and you can receive from
> the child, but you can't converse with the child. Even with the coprocess
> (which is a pain to use), you still have one-way communication at any given
> time. However, 99% of the time, ksh will work fine. For that other 1%
> (OK, maybe 2%), you either figure out a workable compromise with ksh, or
> you use perl.
>
> If you want some reading material, my recommendation is:
>
> Unix System V: A Practical Guide
> by Mark G. Sobel
>
> (There is also a version for BSD)
>
> This is a outstanding overview of Unix including sh, ksh, and csh
> programming; as well as good introductions to sed, awk, and regular
> expressions. It also has chapters on emacs and vi ("Remember, vi is your
> friend."). Amazon has the 3rd edition listed with a publish date of
> 1995. So there probably is some rather outdated info in the book on stuff
> like gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore
> this. All the other stuff is still completely relevant and presented in
> what I think is the perfect level of detail -- not too verbose; not too
> terse -- with good examples.
>
> Eventually, to get seriously cooking with sed and awk, you will need to
> get something like the O'Reilly sed and awk book. But, for ksh
> programming: If you work through the Bourne Shell and Korn Shell chapters
> of the Sobel book, it is likely that this book is all you will ever need.
> Another wonderful thing about this book is that it doesn't use the current
> trend of big fonts with big margins and thick paper to create a monster
> sized book. Instead, you get lots of information in a book that takes up
> little shelf space. --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> 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
>
Re: Programming languages that make DBA's lives easier
Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: > I wonder if I can throw in a further caveat to the choices people would > make? > > If you had to choose a programming language in which to write a program or > application in which you wished to conceal your intellectual property, > which would you use? > > peter > edinburgh > > -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? > > > > * > This e-mail message, and any files transmitted with it, are > confidential and intended solely for the use of the addressee. If > this message was not addressed to you, you have received it in error > and any copying, distribution or other use of any part of it is > strictly prohibited. Any views or opinions presented are solely those > of the sender and do not necessarily represent those of the British > Geological Survey. The security of e-mail communication cannot be > guaranteed and the BGS accepts no liability for claims arising as a > result of the use of this medium to transmit messages from or to the > BGS. The BGS cannot accept any responsibility for viruses, so please > scan all attachments.http://www.bgs.ac.uk > * Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
Re: Programming languages that make DBA's lives easier
I know little about WSH, but it fairly sure it's not a language.
It's a 'scripting host', an engine that allows you to plug in
a scripting language. I believe it even runs Perl. :)
Jared
On Tuesday 18 February 2003 18:43, Maria Aurora VT de la Vega wrote:
> PLSQL, java and shell scripting. Can't say perl...have yet to start
> learning it.
>
> I don't know if you guys are having problems with your batch programs in
> Windows...
> but a few of the old DOS commands I used to use don't work on Win2k
> anymore... like choice. And whenever I search for more information
> regarding Windows scripting...
> I stumble on WSH.
> Any thoughts on this scripting language? Is this worth a DBAs time?
>
> =)
>
> Janardhana Babu Donga wrote:
> > What are the good books you guys recommend for Shell Programming? I have
> > old edition of UNIX shells by example (by Ellie Quigley). I need to
> > replace this with some good book.
> >
> > Do I need to learn perl before reading PERL for DBAs? If so, what are the
> > good perl books do you guys recommend?
> >
> > -- Babu
> >
> > -Original Message-
> > Sent: Tuesday, February 18, 2003 1:04 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > I thought it might be worthwhile to say WHY I prefer ksh for most
> > scripting.
> >
> > As one writer put it, use a language you know. I've used ksh for years,
> > so that is certainly one big factor in preferring it. But, that aside,
> > if you use mostly the Bourne Shell syntax and stay away from the some of
> > the Korn Shell syntactical candy that doesn't do anything extra, then
> > your scripts are very easy to read, and are mostly self-documenting. For
> > me, that is a big advantage.
> >
> > If you use ksh, then you need to become reasonably proficient with a few
> > of the more important utilities such as sed and awk/nawk/gawk and become
> > familiar with good old regular expressions (wonderful stuff!).
> >
> > One area where ksh is weak is its inability to set up a two-way socket
> > with a child process like sqlplus. Perl can do this (for example, by
> > using IPC::Open2). With ksh, you can send to the child, and you can
> > receive from the child, but you can't converse with the child. Even with
> > the coprocess (which is a pain to use), you still have one-way
> > communication at any given time. However, 99% of the time, ksh will work
> > fine. For that other 1% (OK, maybe 2%), you either figure out a workable
> > compromise with ksh, or you use perl.
> >
> > If you want some reading material, my recommendation is:
> >
> > Unix System V: A Practical Guide
> > by Mark G. Sobel
> >
> > (There is also a version for BSD)
> >
> > This is a outstanding overview of Unix including sh, ksh, and csh
> > programming; as well as good introductions to sed, awk, and regular
> > expressions. It also has chapters on emacs and vi ("Remember, vi is your
> > friend."). Amazon has the 3rd edition listed with a publish date of
> > 1995. So there probably is some rather outdated info in the book on stuff
> > like gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore
> > this. All the other stuff is still completely relevant and presented in
> > what I think is the perfect level of detail -- not too verbose; not too
> > terse -- with good examples.
> >
> > Eventually, to get seriously cooking with sed and awk, you will need to
> > get something like the O'Reilly sed and awk book. But, for ksh
> > programming: If you work through the Bourne Shell and Korn Shell chapters
> > of the Sobel book, it is likely that this book is all you will ever need.
> > Another wonderful thing about this book is that it doesn't use the
> > current trend of big fonts with big margins and thick paper to create a
> > monster sized book. Instead, you get lots of information in a book that
> > takes up little shelf space. --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stephen Lee
> > 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: Janardhana Babu Donga
> > 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
>
Re: Programming languages that make DBA's lives easier
Ah, got it. Yes, it is Oracle specific. Jared On Tuesday 18 February 2003 10:03, [EMAIL PROTECTED] wrote: > Jared your right I just see PL/SQL different from other programming > languages from the perspective of its "openness". For example, I write > korn shell scripts to do a number of things not just related to managing an > Oracle database itself. I use C language for a number of things. PL/SQL I > wouldn't use for anything but writing Oracle server-side code. That is > what I meant. > > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 1:00 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Programming languages that make DBA's lives easier > > > > PL/SQL is not a programming language? > > What are your criteria that must be met > before it's a programming language? > > Jared > > On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > > C > > Shell Scripting > > Perl > > Pl/SQL - "not really a programming language" > > Java > > > > Now, if the more developer-minded DBA's amongst us could rate them as % > > important that would be cool! > > > > -Original Message- > > Sent: Tuesday, February 18, 2003 11: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? > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: 7bit > Content-Description: > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
RE: Programming languages that make DBA's lives easier
Great list, but don't forget Tom Christiansen et al.'s Perl Cookbook.
One of the best books written about anything, in my opinion.
If someone's already a ksh or C programmer, then I think the beginning
Perl library should include Wall's "Programming Perl" and the "Perl
Cookbook." To connect to Oracle, you're going to need Descarte and Bunce
"Programming te Perl DBI".
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 25-27 London
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Shell - I have used Unix Shell Programming revised Edition by Kochan and
Wood extensively. It's really all I use for shell programming problems.
It's well-written and not a dry read.
Perl - most everyone I can think of will point you to the O'Reilly
library
of Perl books, starting with Learning Perl (the 'Llama book'), then
going
on to Programming Perl (the 'Camel book'). I have personally found
Orwant's 'Perl 5 Interactive Course: Certified Edition' to be excellent,
but I think it's out of print now. I think you can still get it on
amazon.com. Then comes 'Advanced Perl Programming', 'Programming the
Perl
DBI', and 'Perl for Oracle DBAs' Quite the exhausting list.
Fortunately,
you can get just the Llama & Camel books (optionally Orwant's book in
place
of both), and the DBI book, and munge through publically available
examples, man pages, etc to get most of what you need.
Janardhana Babu Donga
<[EMAIL PROTECTED]>T
To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]
bcc:
Subject:
RE: Programming languages
that make DBA's lives
easier
02/18/2003 05:28 PM
Please respond to
ORACLE-L
What are the good books you guys recommend for Shell Programming? I have
old
edition of UNIX shells by example (by Ellie Quigley). I need to replace
this
with some good book.
Do I need to learn perl before reading PERL for DBAs? If so, what are
the
good perl books do you guys recommend?
-- Babu
-Original Message-
Sent: Tuesday, February 18, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
I thought it might be worthwhile to say WHY I prefer ksh for most
scripting.
As one writer put it, use a language you know. I've used ksh for years,
so
that is certainly one big factor in preferring it. But, that aside, if
you
use mostly the Bourne Shell syntax and stay away from the some of the
Korn
Shell syntactical candy that doesn't do anything extra, then your
scripts
are very easy to read, and are mostly self-documenting. For me, that is
a
big advantage.
If you use ksh, then you need to become reasonably proficient with a few
of
the more important utilities such as sed and awk/nawk/gawk and become
familiar with good old regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a two-way socket
with
a child process like sqlplus. Perl can do this (for example, by using
IPC::Open2). With ksh, you can send to the child, and you can receive
from
the child, but you can't converse with the child. Even with the
coprocess
(which is a pain to use), you still have one-way communication at any
given
time. However, 99% of the time, ksh will work fine. For that other 1%
(OK,
maybe 2%), you either figure out a workable compromise with ksh, or you
use
perl.
If you want some reading material, my recommendation is:
Unix System V: A Practical Guide
by Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and csh
programming; as well as good introductions to sed, awk, and regular
expressions. It also has chapters on emacs and vi ("Remember, vi is
your
friend."). Amazon has the 3rd edition listed with a publish date of
1995.
So there probably is some rather outdated info in the book on stuff like
gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this.
All
the other stuff is still completely relevant and presented in what I
think
is the perfect level of detail -- not too verbose; not too terse -- with
good examples.
Eventually, to get seriously cooking with sed and awk, you will need to
get
something like the O'Reilly sed and awk book. But, for
RE: Programming languages that make DBA's lives easier
I think it would be more appropriate to say. Today is a good day to die! From: "Gogala, Mladen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Programming languages that make DBA's lives easier Date: Wed, 19 Feb 2003 09:59:12 -0800 Live long and prosper! > -Original Message- > From: Stephen Lee [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 9:09 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Programming languages that make DBA's lives easier > > > > Klingon. > > -Original Message- > > If you had to choose a programming language in which to write > a program or > application in which you wished to conceal your intellectual > property, which > would you use? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > 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). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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).
RE: Programming languages that make DBA's lives easier
Shell - I have used Unix Shell Programming revised Edition by Kochan and
Wood extensively. It's really all I use for shell programming problems.
It's well-written and not a dry read.
Perl - most everyone I can think of will point you to the O'Reilly library
of Perl books, starting with Learning Perl (the 'Llama book'), then going
on to Programming Perl (the 'Camel book'). I have personally found
Orwant's 'Perl 5 Interactive Course: Certified Edition' to be excellent,
but I think it's out of print now. I think you can still get it on
amazon.com. Then comes 'Advanced Perl Programming', 'Programming the Perl
DBI', and 'Perl for Oracle DBAs' Quite the exhausting list. Fortunately,
you can get just the Llama & Camel books (optionally Orwant's book in place
of both), and the DBI book, and munge through publically available
examples, man pages, etc to get most of what you need.
Janardhana Babu Donga
<[EMAIL PROTECTED]>T
To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]
bcc:
Subject:
RE: Programming languages
that make DBA's lives easier
02/18/2003 05:28 PM
Please respond to
ORACLE-L
What are the good books you guys recommend for Shell Programming? I have
old
edition of UNIX shells by example (by Ellie Quigley). I need to replace
this
with some good book.
Do I need to learn perl before reading PERL for DBAs? If so, what are the
good perl books do you guys recommend?
-- Babu
-Original Message-
Sent: Tuesday, February 18, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
I thought it might be worthwhile to say WHY I prefer ksh for most
scripting.
As one writer put it, use a language you know. I've used ksh for years, so
that is certainly one big factor in preferring it. But, that aside, if you
use mostly the Bourne Shell syntax and stay away from the some of the Korn
Shell syntactical candy that doesn't do anything extra, then your scripts
are very easy to read, and are mostly self-documenting. For me, that is a
big advantage.
If you use ksh, then you need to become reasonably proficient with a few of
the more important utilities such as sed and awk/nawk/gawk and become
familiar with good old regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a two-way socket with
a child process like sqlplus. Perl can do this (for example, by using
IPC::Open2). With ksh, you can send to the child, and you can receive from
the child, but you can't converse with the child. Even with the coprocess
(which is a pain to use), you still have one-way communication at any given
time. However, 99% of the time, ksh will work fine. For that other 1%
(OK,
maybe 2%), you either figure out a workable compromise with ksh, or you use
perl.
If you want some reading material, my recommendation is:
Unix System V: A Practical Guide
by Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and csh
programming; as well as good introductions to sed, awk, and regular
expressions. It also has chapters on emacs and vi ("Remember, vi is your
friend."). Amazon has the 3rd edition listed with a publish date of 1995.
So there probably is some rather outdated info in the book on stuff like
gopher,
RE: Programming languages that make DBA's lives easier
Live long and prosper! > -Original Message- > From: Stephen Lee [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 9:09 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Programming languages that make DBA's lives easier > > > > Klingon. > > -Original Message- > > If you had to choose a programming language in which to write > a program or > application in which you wished to conceal your intellectual > property, which > would you use? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > 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).
RE: Programming languages that make DBA's lives easier
Frighteningly enough, Damian Conway has produced some wonderfully hideous
Perl modules that allows you to write your code in Klingon. It even does
it in object-oriented style (method overloading in Klingon - ack!).
Stephen Lee
<[EMAIL PROTECTED]> T
To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]
bcc:
Subject:
RE: Programming languages
that make DBA's lives easier
02/19/2003 09:08 AM
Please respond to
ORACLE-L
Klingon.
-Original Message-
If you had to choose a programming language in which to write a program or
application in which you wished to conceal your intellectual property,
which
would you use?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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:
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).
RE: Programming languages that make DBA's lives easier
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 JesseSystem/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).
Re: Programming languages that make DBA's lives easier
On Wed, Feb 19, 2003 at 06:08:53AM -0800, Stephen Lee wrote: > > Klingon. so you can speak to the sysadmins... > > -Original Message- > > If you had to choose a programming language in which to write a program or > application in which you wished to conceal your intellectual property, which > would you use? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
RE: Programming languages that make DBA's lives easier
Klingon. -Original Message- If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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).
RE: Programming languages that make DBA's lives easier
AFAIK NOT shell scripts NOT batchscript anything else probably works for you Jack -Original Message-From: Robson, Peter [mailto:[EMAIL PROTECTED]]Sent: woensdag 19 februari 2003 12:34To: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that make DBA's lives easier I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Les AyudoSent: Tuesday, February 18, 2003 10:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?*This e-mail message, and any files transmitted with it, areconfidential and intended solely for the use of the addressee. Ifthis message was not addressed to you, you have received it in errorand any copying, distribution or other use of any part of it isstrictly prohibited. Any views or opinions presented are solely thoseof the sender and do not necessarily represent those of the BritishGeological Survey. The security of e-mail communication cannot beguaranteed and the BGS accepts no liability for claims arising as aresult of the use of this medium to transmit messages from or to theBGS. The BGS cannot accept any responsibility for viruses, so pleasescan all attachments. http://www.bgs.ac.uk*
RE: Programming languages that make DBA's lives easier
I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Les AyudoSent: Tuesday, February 18, 2003 10:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk *
Re: Programming languages that make DBA's lives easier
PLSQL, java and shell scripting. Can't say perl...have yet to start learning it.
I don't know if you guys are having problems with your batch programs in
Windows...
but a few of the old DOS commands I used to use don't work on Win2k anymore...
like choice. And whenever I search for more information regarding Windows
scripting...
I stumble on WSH.
Any thoughts on this scripting language? Is this worth a DBAs time?
=)
Janardhana Babu Donga wrote:
> What are the good books you guys recommend for Shell Programming? I have old
> edition of UNIX shells by example (by Ellie Quigley). I need to replace this
> with some good book.
>
> Do I need to learn perl before reading PERL for DBAs? If so, what are the
> good perl books do you guys recommend?
>
> -- Babu
>
> -Original Message-
> Sent: Tuesday, February 18, 2003 1:04 PM
> To: Multiple recipients of list ORACLE-L
>
> I thought it might be worthwhile to say WHY I prefer ksh for most scripting.
>
> As one writer put it, use a language you know. I've used ksh for years, so
> that is certainly one big factor in preferring it. But, that aside, if you
> use mostly the Bourne Shell syntax and stay away from the some of the Korn
> Shell syntactical candy that doesn't do anything extra, then your scripts
> are very easy to read, and are mostly self-documenting. For me, that is a
> big advantage.
>
> If you use ksh, then you need to become reasonably proficient with a few of
> the more important utilities such as sed and awk/nawk/gawk and become
> familiar with good old regular expressions (wonderful stuff!).
>
> One area where ksh is weak is its inability to set up a two-way socket with
> a child process like sqlplus. Perl can do this (for example, by using
> IPC::Open2). With ksh, you can send to the child, and you can receive from
> the child, but you can't converse with the child. Even with the coprocess
> (which is a pain to use), you still have one-way communication at any given
> time. However, 99% of the time, ksh will work fine. For that other 1% (OK,
> maybe 2%), you either figure out a workable compromise with ksh, or you use
> perl.
>
> If you want some reading material, my recommendation is:
>
> Unix System V: A Practical Guide
> by Mark G. Sobel
>
> (There is also a version for BSD)
>
> This is a outstanding overview of Unix including sh, ksh, and csh
> programming; as well as good introductions to sed, awk, and regular
> expressions. It also has chapters on emacs and vi ("Remember, vi is your
> friend."). Amazon has the 3rd edition listed with a publish date of 1995.
> So there probably is some rather outdated info in the book on stuff like
> gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All
> the other stuff is still completely relevant and presented in what I think
> is the perfect level of detail -- not too verbose; not too terse -- with
> good examples.
>
> Eventually, to get seriously cooking with sed and awk, you will need to get
> something like the O'Reilly sed and awk book. But, for ksh programming: If
> you work through the Bourne Shell and Korn Shell chapters of the Sobel book,
> it is likely that this book is all you will ever need. Another wonderful
> thing about this book is that it doesn't use the current trend of big fonts
> with big margins and thick paper to create a monster sized book. Instead,
> you get lots of information in a book that takes up little shelf space.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> 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: Janardhana Babu Donga
> 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).
--
Maria Aurora VT de la Vega
Oracle DBA
Philippine Stock Exchange, Inc.
"Failure is only postponed success as long as courage 'coaches' ambition.
The habit of persistence is the habit o
RE: Programming languages that make DBA's lives easier
exec DBMS_SHAWM.PLAY('CHARMER')
> -Original Message-
> Cool! How'd you get Python to run from a DBMS_JOB?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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).
RE: Programming languages that make DBA's lives easier
The choices would be vary, I suggest you to learn everything you need to learn. > -Original Message- > From: Les Ayudo [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 11:56 PM > To: Multiple recipients of list ORACLE-L > Subject: Programming languages that make DBA's lives easier > > 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: Sony kristanto 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).
Re: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier
I have Unix Shell Programming revised Edition by
Kochan and Wood. Haven't had time to sit down and read it but it's
supposed to be really good.
- Original Message -
From:
Nick
Wagner
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, February 18, 2003 3:08
PM
Subject: RE: Programming languages that
make DBA's lives easier
If you are just learning Korn Shell programming, I'd recommend
The Korn Shell (3rd edition) by
Anatole Olczak
it's better than others I have seen, but basic... you won't
get deep enough to make any huge programs, but it should be enough for you're
Oracle DBA needs.
-Original Message- From:
Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier
What are the good books you guys recommend for Shell
Programming? I have old edition of UNIX shells by
example (by Ellie Quigley). I need to replace this with some good book.
Do I need to learn perl before reading PERL for DBAs? If so,
what are the good perl books do you guys recommend?
-- Babu
-Original Message- Sent:
Tuesday, February 18, 2003 1:04 PM To: Multiple
recipients of list ORACLE-L
I thought it might be worthwhile to say WHY I prefer ksh for
most scripting.
As one writer put it, use a language you know. I've used
ksh for years, so that is certainly one big factor in
preferring it. But, that aside, if you use
mostly the Bourne Shell syntax and stay away from the some of the Korn
Shell syntactical candy that doesn't do anything extra, then
your scripts are very easy to read, and are mostly
self-documenting. For me, that is a big
advantage.
If you use ksh, then you need to become reasonably proficient
with a few of the more important utilities such as sed
and awk/nawk/gawk and become familiar with good old
regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a
two-way socket with a child process like
sqlplus. Perl can do this (for example, by using IPC::Open2). With ksh, you can send to the child, and you can
receive from the child, but you can't converse with
the child. Even with the coprocess (which is a
pain to use), you still have one-way communication at any given
time. However, 99% of the time, ksh will work
fine. For that other 1% (OK, maybe 2%), you
either figure out a workable compromise with ksh, or you use perl.
If you want some reading material, my recommendation
is:
Unix System V: A Practical Guide by
Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and
csh programming; as well as good introductions to sed,
awk, and regular expressions. It also has
chapters on emacs and vi ("Remember, vi is your friend."). Amazon has the 3rd edition listed with a publish date
of 1995. So there probably is some rather outdated
info in the book on stuff like gopher, archie,
possibly Mosaic (Oh hey, cool!). Just ignore this. All
the other stuff is still completely relevant and presented in
what I think is the perfect level of detail -- not too
verbose; not too terse -- with good examples.
Eventually, to get seriously cooking with sed and awk, you
will need to get something like the O'Reilly sed and
awk book. But, for ksh programming: If you work
through the Bourne Shell and Korn Shell chapters of the Sobel book,
it is likely that this book is all you will ever need.
Another wonderful thing about this book is that it
doesn't use the current trend of big fonts with big
margins and thick paper to create a monster sized book. Instead,
you get lots of information in a book that takes up little
shelf space. -- Please see the
official ORACLE-L FAQ: http://www.orafaq.net --
Author: Stephen Lee
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: Janardhana Babu Donga INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier
If you are just learning Korn Shell programming, I'd recommend
The Korn Shell (3rd edition)
by Anatole Olczak
it's better than others I have seen, but basic... you won't get deep enough to make any huge programs, but it should be enough for you're Oracle DBA needs.
-Original Message-
From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Programming languages that make DBA's lives easier
What are the good books you guys recommend for Shell Programming? I have old
edition of UNIX shells by example (by Ellie Quigley). I need to replace this
with some good book.
Do I need to learn perl before reading PERL for DBAs? If so, what are the
good perl books do you guys recommend?
-- Babu
-Original Message-
Sent: Tuesday, February 18, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
I thought it might be worthwhile to say WHY I prefer ksh for most scripting.
As one writer put it, use a language you know. I've used ksh for years, so
that is certainly one big factor in preferring it. But, that aside, if you
use mostly the Bourne Shell syntax and stay away from the some of the Korn
Shell syntactical candy that doesn't do anything extra, then your scripts
are very easy to read, and are mostly self-documenting. For me, that is a
big advantage.
If you use ksh, then you need to become reasonably proficient with a few of
the more important utilities such as sed and awk/nawk/gawk and become
familiar with good old regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a two-way socket with
a child process like sqlplus. Perl can do this (for example, by using
IPC::Open2). With ksh, you can send to the child, and you can receive from
the child, but you can't converse with the child. Even with the coprocess
(which is a pain to use), you still have one-way communication at any given
time. However, 99% of the time, ksh will work fine. For that other 1% (OK,
maybe 2%), you either figure out a workable compromise with ksh, or you use
perl.
If you want some reading material, my recommendation is:
Unix System V: A Practical Guide
by Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and csh
programming; as well as good introductions to sed, awk, and regular
expressions. It also has chapters on emacs and vi ("Remember, vi is your
friend."). Amazon has the 3rd edition listed with a publish date of 1995.
So there probably is some rather outdated info in the book on stuff like
gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All
the other stuff is still completely relevant and presented in what I think
is the perfect level of detail -- not too verbose; not too terse -- with
good examples.
Eventually, to get seriously cooking with sed and awk, you will need to get
something like the O'Reilly sed and awk book. But, for ksh programming: If
you work through the Bourne Shell and Korn Shell chapters of the Sobel book,
it is likely that this book is all you will ever need. Another wonderful
thing about this book is that it doesn't use the current trend of big fonts
with big margins and thick paper to create a monster sized book. Instead,
you get lots of information in a book that takes up little shelf space.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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: Janardhana Babu Donga
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).
RE: Programming languages that make DBA's lives easier
What are the good books you guys recommend for Shell Programming? I have old
edition of UNIX shells by example (by Ellie Quigley). I need to replace this
with some good book.
Do I need to learn perl before reading PERL for DBAs? If so, what are the
good perl books do you guys recommend?
-- Babu
-Original Message-
Sent: Tuesday, February 18, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
I thought it might be worthwhile to say WHY I prefer ksh for most scripting.
As one writer put it, use a language you know. I've used ksh for years, so
that is certainly one big factor in preferring it. But, that aside, if you
use mostly the Bourne Shell syntax and stay away from the some of the Korn
Shell syntactical candy that doesn't do anything extra, then your scripts
are very easy to read, and are mostly self-documenting. For me, that is a
big advantage.
If you use ksh, then you need to become reasonably proficient with a few of
the more important utilities such as sed and awk/nawk/gawk and become
familiar with good old regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a two-way socket with
a child process like sqlplus. Perl can do this (for example, by using
IPC::Open2). With ksh, you can send to the child, and you can receive from
the child, but you can't converse with the child. Even with the coprocess
(which is a pain to use), you still have one-way communication at any given
time. However, 99% of the time, ksh will work fine. For that other 1% (OK,
maybe 2%), you either figure out a workable compromise with ksh, or you use
perl.
If you want some reading material, my recommendation is:
Unix System V: A Practical Guide
by Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and csh
programming; as well as good introductions to sed, awk, and regular
expressions. It also has chapters on emacs and vi ("Remember, vi is your
friend."). Amazon has the 3rd edition listed with a publish date of 1995.
So there probably is some rather outdated info in the book on stuff like
gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All
the other stuff is still completely relevant and presented in what I think
is the perfect level of detail -- not too verbose; not too terse -- with
good examples.
Eventually, to get seriously cooking with sed and awk, you will need to get
something like the O'Reilly sed and awk book. But, for ksh programming: If
you work through the Bourne Shell and Korn Shell chapters of the Sobel book,
it is likely that this book is all you will ever need. Another wonderful
thing about this book is that it doesn't use the current trend of big fonts
with big margins and thick paper to create a monster sized book. Instead,
you get lots of information in a book that takes up little shelf space.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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: Janardhana Babu Donga
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).
RE: Programming languages that make DBA's lives easier
No offense taken. Depending on the shop, java may be more critical than perl. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Paula_Stankus@doh. state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Programming languages that make DBA's lives easier 02/18/2003 01:23 PM Please respond to ORACLE-L No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to 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: Ron Thomas 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: Ron Thomas 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).
RE: Programming languages that make DBA's lives easier
Cool! How'd you get Python to run from a DBMS_JOB? :D Rich Rich JesseSystem/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.html#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).
Re: Programming languages that make DBA's lives easier
On Tue, Feb 18, 2003 at 12:23:49PM -0800, [EMAIL PROTECTED] wrote: > No offense By definition there must be an offense in a holy war! > but I have noticed in the various Unix/Oracle shops I have worked > that more sys. admins. and Unix types knew korn shell prog. and Java then > Perl. > > -Original Message- > Sent: Tuesday, February 18, 2003 12:20 PM > To: Multiple recipients of list ORACLE-L > > > > Let the Holy Wars begin... > > My choice: > > korn shell > perl > pl/sql > > Ron Thomas > Hypercom, Inc > [EMAIL PROTECTED] > Each new user of a new system uncovers a new class of bugs. -- Kernighan > > > > > [EMAIL PROTECTED] > > Sent by: To: > [EMAIL PROTECTED] > > [EMAIL PROTECTED] cc: > >Subject: Programming > languages that make DBA's lives easier > > > 02/18/2003 09:56 > > AM > > Please respond to > > 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: Ron Thomas > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier 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.html To know Python is to love Python. Language redactionist, minimalist, extremist, pacifist... -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier A list of languages doesnt 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. Its 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. Theres also the Perl for Oracle DBAs book, which is very popular among folks on this list. (Sorry, Jared! Its 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. Its needed for us because itll give us a way to replace some icky VB apps whose sole purpose is to e-mail from an app. Ive 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 dont know Java much, but have been able to glean enough to pull this off. 5) Tcl. We dont 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. :) Thats my $.02. Enjoy! :) Rich
RE: Programming languages that make DBA's lives easier
I thought it might be worthwhile to say WHY I prefer ksh for most scripting.
As one writer put it, use a language you know. I've used ksh for years, so
that is certainly one big factor in preferring it. But, that aside, if you
use mostly the Bourne Shell syntax and stay away from the some of the Korn
Shell syntactical candy that doesn't do anything extra, then your scripts
are very easy to read, and are mostly self-documenting. For me, that is a
big advantage.
If you use ksh, then you need to become reasonably proficient with a few of
the more important utilities such as sed and awk/nawk/gawk and become
familiar with good old regular expressions (wonderful stuff!).
One area where ksh is weak is its inability to set up a two-way socket with
a child process like sqlplus. Perl can do this (for example, by using
IPC::Open2). With ksh, you can send to the child, and you can receive from
the child, but you can't converse with the child. Even with the coprocess
(which is a pain to use), you still have one-way communication at any given
time. However, 99% of the time, ksh will work fine. For that other 1% (OK,
maybe 2%), you either figure out a workable compromise with ksh, or you use
perl.
If you want some reading material, my recommendation is:
Unix System V: A Practical Guide
by Mark G. Sobel
(There is also a version for BSD)
This is a outstanding overview of Unix including sh, ksh, and csh
programming; as well as good introductions to sed, awk, and regular
expressions. It also has chapters on emacs and vi ("Remember, vi is your
friend."). Amazon has the 3rd edition listed with a publish date of 1995.
So there probably is some rather outdated info in the book on stuff like
gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All
the other stuff is still completely relevant and presented in what I think
is the perfect level of detail -- not too verbose; not too terse -- with
good examples.
Eventually, to get seriously cooking with sed and awk, you will need to get
something like the O'Reilly sed and awk book. But, for ksh programming: If
you work through the Bourne Shell and Korn Shell chapters of the Sobel book,
it is likely that this book is all you will ever need. Another wonderful
thing about this book is that it doesn't use the current trend of big fonts
with big margins and thick paper to create a monster sized book. Instead,
you get lots of information in a book that takes up little shelf space.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: Programming languages that make DBA's lives easier Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to 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: Ron Thomas 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).
RE: Programming languages that make DBA's lives easier
Borland tools... We have an app that was built using Borland C++, we are getting bizarre Dr.Watson errors on the NT server, regarding a ShlObj.pas unit and a SHBrowseForFolder API call. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that make DBA's lives easier you can take the (more unix friendly) ksh c c++ Java path, all those languages are very similar, or the (more windows friendly) pl/sql Delphi path... if you know pl/sql... delphi should come pretty easily. If you know ksh, or c, then c++ and Java will come pretty easily... focus on your strengths, you don't want to spend the rest of your days working on something you're not good at. Nick -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 8:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Programming languages that make DBA's lives easier
A list of languages doesnt 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. Its 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. Theres also the Perl for Oracle DBAs book, which is very popular among folks on this list. (Sorry, Jared! Its 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. Its needed for us because itll give us a way to replace some icky VB apps whose sole purpose is to e-mail from an app. Ive 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 dont know Java much, but have been able to glean enough to pull this off. 5) Tcl. We dont 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. :) Thats my $.02. Enjoy! :) Rich Rich JesseSystem/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).
RE: Programming languages that make DBA's lives easier
#1, 2 are a must. #3 should be whatever your favor langauage whether it's Perl or Java or C etc. Richard -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: >You need to know PL/SQL if you're going to be effective with Oracle. > >Java is interesting, but not nearly as useful to a DBA as Perl. > >Jared > >On Tuesday 18 February 2003 08:56, 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? > > >Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" >Content-Transfer-Encoding: quoted-printable >Content-Description: > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jared Still > 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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: Kevin Lange 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: Richard Ji 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).
RE: Programming languages that make DBA's lives easier
Microsoft DOS scripting for the Windows side. Patrice Boivin -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, 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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Boivin, Patrice J 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).
RE: Programming languages that make DBA's lives easier
My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: >You need to know PL/SQL if you're going to be effective with Oracle. > >Java is interesting, but not nearly as useful to a DBA as Perl. > >Jared > >On Tuesday 18 February 2003 08:56, 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? > > >Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" >Content-Transfer-Encoding: quoted-printable >Content-Description: > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jared Still > 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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: Kevin Lange 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).
Re: Programming languages that make DBA's lives easier
See, that depends on how big a shop you run. I have to pull duty as the sysadmin as well. If the installer does not work, a relink fails, etc, I can't call my unix guy and ask for it to be fixed. I have found many problems with the install programs as shipped by oracle, especially on Linux (all the way back to 8.0.5, iirc, up to and including 9iR2). Not all the problems can be fixed with knowledge of C, but if you know what the program is doing, or if you can slog your way through the makefile, you have a better chance of fixing it. If you can't get oracle installed, then there isn't much need for a dba, now is there? -Candi On Tue, 2003-02-18 at 12:59, Jared Still wrote: > On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > > C > > Not much need for most DBA's to ever use C, though > not a bad thing to know. > > Certainly doesn't belong at the top of the list for a DBA. > > Jraed > > > Shell Scripting > > Perl > > Pl/SQL - "not really a programming language" > > Java > > > > Now, if the more developer-minded DBA's amongst us could rate them as % > > important that would be cool! > > > > -Original Message- > > Sent: Tuesday, February 18, 2003 11: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? > > > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: 7bit > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > 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: Boyle Candi 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).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier Programming languages that make DBA's lives easier: The ones you already know and feel comfortable with. (Of course Oracle connectivity is a basic requirement.) Programming languages that make DBA's lives HARDER: The ones forced on you by others. The ones that you don't know which are harder to learn, harder to read, and/or have a lower productivity quotient: C; Java; Perl. :-) Programs that make DBA's lives hellish: The ones written by someone else. Especially poorly written programs/scripts with poor documentation and poor technique. Attitudes which make a DBA's life easier: Insatiable curiosity and the joy of learning new things. Holy Warrior... -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter
RE: Programming languages that make DBA's lives easier
you can take the (more unix friendly) ksh c c++ Java path, all those languages are very similar, or the (more windows friendly) pl/sql Delphi path... if you know pl/sql... delphi should come pretty easily. If you know ksh, or c, then c++ and Java will come pretty easily... focus on your strengths, you don't want to spend the rest of your days working on something you're not good at. Nick -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 8:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier Jared your right I just see PL/SQL different from other programming languages from the perspective of its "openness". For example, I write korn shell scripts to do a number of things not just related to managing an Oracle database itself. I use C language for a number of things. PL/SQL I wouldn't use for anything but writing Oracle server-side code. That is what I meant. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Programming languages that make DBA's lives easier PL/SQL is not a programming language? What are your criteria that must be met before it's a programming language? Jared On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > C > Shell Scripting > Perl > Pl/SQL - "not really a programming language" > Java > > Now, if the more developer-minded DBA's amongst us could rate them as % > important that would be cool! > > -Original Message- > Sent: Tuesday, February 18, 2003 11: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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description:
Re: Programming languages that make DBA's lives easier
What's your goal? If you are writing scripts then use perl or python. IMO, python is more maintainable when your codebase gets bigger. If you're writing a system or application python is still good. If your goal is to get on the hype then go java, xml, .net, and throw in a webservice API. Also, you don't need to know how these work, but you do need to know how to use the wizards that can generate code for these. On Tue, 18 Feb 2003, 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? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex 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).
Re: Programming languages that make DBA's lives easier
You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, 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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
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: [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).
Re: Programming languages that make DBA's lives easier
On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > C Not much need for most DBA's to ever use C, though not a bad thing to know. Certainly doesn't belong at the top of the list for a DBA. Jraed > Shell Scripting > Perl > Pl/SQL - "not really a programming language" > Java > > Now, if the more developer-minded DBA's amongst us could rate them as % > important that would be cool! > > -Original Message- > Sent: Tuesday, February 18, 2003 11: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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
Re: Programming languages that make DBA's lives easier
In my opinion, there are languages you learn because you'll have to deal with them whether it is to make use of a good set of scripts that someone has made available, or programs you'll need to maintain at some level. And there are languages you learn because they allow you to quickly and efficiently get stuff done. There is overlap between categories, but in category 1, I generally place the likes of Perl, C, PL/SQL, ksh, Java and the like. In category 2, I prefer Python; Perl goes here too for many DBA's. Glenn Stauffer - Original Message - From: Les Ayudo To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 18, 2003 11:56 AM Subject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
Re: Programming languages that make DBA's lives easier
I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, 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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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).
RE: Programming languages that make DBA's lives easier
If you are using C/C++ look into www.swig.org to make your life easier On Tue, 18 Feb 2003 [EMAIL PROTECTED] wrote: > C > Shell Scripting > Perl > Pl/SQL - "not really a programming language" > Java > > Now, if the more developer-minded DBA's amongst us could rate them as % > important that would be cool! > > -Original Message- > Sent: Tuesday, February 18, 2003 11: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: Alex 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).
Re: Programming languages that make DBA's lives easier
PL/SQL is not a programming language? What are your criteria that must be met before it's a programming language? Jared On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: > C > Shell Scripting > Perl > Pl/SQL - "not really a programming language" > Java > > Now, if the more developer-minded DBA's amongst us could rate them as % > important that would be cool! > > -Original Message- > Sent: Tuesday, February 18, 2003 11: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? Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
Re: Programming languages that make DBA's lives easier
I have always found that both C and understanding makefiles were fundamental to running oracle on linux/unix. When the installer breaks, the knowledge comes in handy. And the installer seems to break quite often... -Candi On Tue, 2003-02-18 at 11:56, 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? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi 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).
RE: Programming languages that make DBA's lives easier
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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).
RE: Programming languages that make DBA's lives easier
In priority order, I would recommend: SQL Whatever language your apps are written in: it’s probably Java or PL/SQL, but it might be anything (PHP, Perl, VB, ASP, Python, Tcl, C, C++, C#, ksh, csh, sh, etc.). If you’ve not found your job yet, then the best bets are Java and PL/SQL. Whatever language your database and system administration staff use to do their jobs. If you’ve not found your job yet, then I’d submit that the best one to start with is Perl. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5–6 Denver - Hotsos Clinic 101, Mar 25–27 London -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Les Ayudo Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L Subject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Programming languages that make DBA's lives easier
On Unix, ksh. VERY useful for automating maintenance. -Original Message- 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: Stephen Lee 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).
RE: Programming languages that make DBA's lives easier
C Shell Scripting Perl Pl/SQL - "not really a programming language" Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
Re: Programming languages that make DBA's lives easier
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to 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: Ron Thomas 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).
