RE: DBA tools on NT - PERL
Bob, I don't have mine either. :( My editor just received a copy on Monday, so they have been printed, and should be shipping now. Jared "Bob Metelsky" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: DBA tools on NT - PERL I ve ordered the book from Oreilly about 2 weeks ago and at that time it was not avaiable. http://www.oreilly.com/catalog/oracleperl/ Jared, do you know when the book will be shipped? Im really looking forward to this. Ive setup the DBI and Oracle modules can connect and querry the database the suspense is killing me. ;-) thanks bob I am going to buy Jared book. He wrote to me that the book is currently available on Amazon. You can use www.perl.com to supplement tour needs. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 7:53 PM > -Original Message- > From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] > > I'm not responding to any single message here but a few general > comments about perl. All right already! I'll quit using C/gcc and start using Perl! Is this the first book I need? Learning Perl, 3rd Edition Making Easy Things Easy and Hard Things Possible By Randal L. Schwartz, Tom Phoenix 3rd Edition July 2001 0-596-00132-0, Order Number: 1320 http://www.oreilly.com/catalog/lperl3/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DBA tools on NT - PERL
Title: Message I ve ordered the book from Oreilly about 2 weeks ago and at that time it was not avaiable. http://www.oreilly.com/catalog/oracleperl/ Jared, do you know when the book will be shipped? Im really looking forward to this. Ive setup the DBI and Oracle modules can connect and querry the database the suspense is killing me. ;-) thanks bob I am going to buy Jared book. He wrote to me that the book is currently available on Amazon. You can use www.perl.com to supplement tour needs. Yechiel AdarMehish - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 7:53 PM Subject: RE: DBA tools on NT - PERL > -Original Message- > From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] > > I'm not responding to any single message here but a few general > comments about perl. All right already! I'll quit using C/gcc and start using Perl! Is this the first book I need? Learning Perl, 3rd Edition Making Easy Things Easy and Hard Things Possible By Randal L. Schwartz, Tom Phoenix 3rd Edition July 2001 0-596-00132-0, Order Number: 1320 http://www.oreilly.com/catalog/lperl3/
Re: DBA tools on NT - PERL
Title: RE: DBA tools on NT - PERL I am going to buy Jared book. He wrote to me that the book is currently available on Amazon. You can use www.perl.com to supplement tour needs. Yechiel AdarMehish - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 7:53 PM Subject: RE: DBA tools on NT - PERL > -Original Message- > From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] > > I'm not responding to any single message here but a few general > comments about perl. All right already! I'll quit using C/gcc and start using Perl! Is this the first book I need? Learning Perl, 3rd Edition Making Easy Things Easy and Hard Things Possible By Randal L. Schwartz, Tom Phoenix 3rd Edition July 2001 0-596-00132-0, Order Number: 1320 http://www.oreilly.com/catalog/lperl3/
RE: RE: Dba tools on NT
Thank you... more books to add to my wish list. And I wonder why my mom looks at me strangely when I tell her what I want for Hannukah.. --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Perl comes with Oracle for Unix too, with 9iAS. > > Side comment: I think an important part of why Perl is so useful (and > so > widely used) is the existence of two of the best technical books ever > written: > > * Wall, Christiansen, Orwant: Programming Perl (O'Reilly) > * Christiansen, Torkington: Perl Cookbook (O'Reilly) > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 > Honolulu > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 > Dallas > - Next event: NCOAUG Training Day, Aug 16 Chicago > > > > -Original Message- > Neyman > Sent: Friday, August 16, 2002 8:54 AM > To: Multiple recipients of list ORACLE-L > > > Jared > > > > PS. Just wait, Oracle may have some Perl comin' at you. > > > > On Windows installed by default with Apache (Oracle Enterprise > Edition > 9.2). > > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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.com > -- > Author: Cary Millsap > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
Perl comes with Oracle for Unix too, with 9iAS. Side comment: I think an important part of why Perl is so useful (and so widely used) is the existence of two of the best technical books ever written: * Wall, Christiansen, Orwant: Programming Perl (O'Reilly) * Christiansen, Torkington: Perl Cookbook (O'Reilly) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: NCOAUG Training Day, Aug 16 Chicago -Original Message- Neyman Sent: Friday, August 16, 2002 8:54 AM To: Multiple recipients of list ORACLE-L > Jared > > PS. Just wait, Oracle may have some Perl comin' at you. > On Windows installed by default with Apache (Oracle Enterprise Edition 9.2). Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DBA tools on NT - PERL
Title: RE: DBA tools on NT - PERL > -Original Message- > From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] > > I'm not responding to any single message here but a few general > comments about perl. All right already! I'll quit using C/gcc and start using Perl! Is this the first book I need? Learning Perl, 3rd Edition Making Easy Things Easy and Hard Things Possible By Randal L. Schwartz, Tom Phoenix 3rd Edition July 2001 0-596-00132-0, Order Number: 1320 http://www.oreilly.com/catalog/lperl3/
RE: RE: Dba tools on NT
In the form of RDS? I believe that was the strong rumor on this list a few months back... Makes sense, IMHO, for cross-platform thing-a-ma-bobs. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 6:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Dba tools on NT > > > Being in the majority doesn't make you right, > but I'll buy you a beer anyway. :) > > Jared > > PS. Just wait, Oracle may have some Perl comin' at you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
> Jared > > PS. Just wait, Oracle may have some Perl comin' at you. > On Windows installed by default with Apache (Oracle Enterprise Edition 9.2). Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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[2]: Re[2]: RE: Dba tools on NT
Something of my creation, OK I pilfered most of it, MANY years ago that got stuck into a C language library. Haven't modified it in years(1988) other than recompiling the library and it still works like a dream. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 8/15/2002 3:15 PM Dick, What is 'export_to_file'? Your own function, or something of Oracle's? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2002 08:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re[2]: RE: Dba tools on NT One of the things I love about doing C code is your ability to create libraries and/or DLL's on NT (.so files on Unix, which I haven't mastered yet). When one of our developers asked HOW DO I DO THIS some months ago, we wrote the following code: void main(int argc, char *argv[]) { char stmt[1000]; if(!logon(argv[1], argv[2], argv[3])) { printf("Cannot connect to database %s\n", argv[3]); exit(1); } sprintf(stmt, "SELECT * FROM %s\0", argv[5]); export_to_file(argv[4], stmt); logoff(1); exit(0); } Worked like a champ. Dick Goulet Reply Separator Author: Jared Still <[EMAIL PROTECTED]> Date: 8/14/2002 10:53 PM Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ",", and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with a little experience. Jared On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > readable. uh huh. sure > > how does this create a csv file? > > --- [EMAIL PROTECTED] wrote: > > How many of those "non-cryptic" languages can dump a table > > to a CSV file in 2 lines of (readable ) code? > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > >} > > > > Come over to the dark side Chris. ;) > > > > Jared > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: RE: Dba tools on NT > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > I just have some issues with a language that has more special > > characters > > in > > it then alpha characters. > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > little > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 5:32 PM > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > I'll agree with Jared. Given any programming or scripting language > > and > > there's > > some duhveloper out there who can make a completely obfuscated mess > > out of > > it. > > I was once told that it was impossible under Ada, boy did that ever > > get > > retracted by the author in a hurry!! > > > > Dick Goulet > > > > Reply Separator > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > Date: 8/13/2002 2:06 PM > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > for > > it's "readability" and "maintainability". I'm not slamming Perl, it > > has > > saved my behind on W2K platforms, which has no real scripting > > language. > > And > > I did advance order a copy of your book. Not that I want to be a > > Duhveloper... > > > > > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 4:42 PM > > To: [EMAIL PROTECTED] > > Cc: Grabowy, Chris > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > done, > > and > > > > > impossible to maintain... > > > > Of course, you can say this about any programming or scripting > > language. > > > > It all depends on the ability of the programmer. > > > > Jared > > > > > > > > > >
RE: RE: Dba tools on NT
Being in the majority doesn't make you right, but I'll buy you a beer anyway. :) Jared PS. Just wait, Oracle may have some Perl comin' at you. "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2002 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Dba tools on NT (reading all the replies from others, putting my feet up) I rest my case... Does that make it two kegs of beer you owe me? -Original Message- Sent: Thursday, August 15, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ",", and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with a little experience. Jared On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > readable. uh huh. sure > > how does this create a csv file? > > --- [EMAIL PROTECTED] wrote: > > How many of those "non-cryptic" languages can dump a table > > to a CSV file in 2 lines of (readable ) code? > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > >} > > > > Come over to the dark side Chris. ;) > > > > Jared > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: RE: Dba tools on NT > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > I just have some issues with a language that has more special > > characters > > in > > it then alpha characters. > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > little > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 5:32 PM > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > I'll agree with Jared. Given any programming or scripting language > > and > > there's > > some duhveloper out there who can make a completely obfuscated mess > > out of > > it. > > I was once told that it was impossible under Ada, boy did that ever > > get > > retracted by the author in a hurry!! > > > > Dick Goulet > > > > Reply Separator > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > Date: 8/13/2002 2:06 PM > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > for > > it's "readability" and "maintainability". I'm not slamming Perl, it > > has > > saved my behind on W2K platforms, which has no real scripting > > language. > > And > > I did advance order a copy of your book. Not that I want to be a > > Duhveloper... > > > > > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 4:42 PM > > To: [EMAIL PROTECTED] > > Cc: Grabowy, Chris > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > done, > > and > > > > > impossible to maintain... > > > > Of course, you can say this about any programming or scripting > > language. > > > > It all depends on the ability of the programmer. > > > > Jared > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/13/2002 10:24 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Dba tools on NT > > > > > > And it's difficult to write, looks like scrambled eggs when your > > done, and > > impossible to maintain... > > > > On the other hand, you could write the entire Windows XP operating > > system > > in > > one line of Perl...including Internet Explorer. > > > > -Original Message- >
RE: DBA tools on NT - PERL
I'm not responding to any single message here but a few general comments about perl. First of all I don't care what language you are talking about if you have never used it you probably will see something that you don't understand if someone shows you a program. Therefore, not understanding Jared's small program doesn't mean that perl is hard. After all if you have used || to mean or, seeing it used in SQL queries or PL/SQL to mean concatenation is going to cause some confusion until you have some idea of its meaning in this context. Although I have not had an opportunity to do much with perl recently, I was one who got people looking at perl when we moved off a mainframe and onto UNIX about ten years ago. Why? Because of what I was able to do with it. I was able to come up with things in a short period of time that might or might not be needed again. Some of these quick fixes became more than that - correcting a bad translation of a couple of characters when reading those IMB standard label tapes into an ASCII file was easy for perl and important to the eventual users of the file. Even then I didn't consider myself a perl expert - it was just very easy to pick up and extremely useful. I think it might be relevent to mention how I heard about perl in the first place. It was not from a techie but rather from a librarian. At that point I was more of the exception than the rule in a position of dealing with large machine readable datasets that our faculty and graduate students use for secondary research - in a lot of schools at that time the data was looked at as being infomation that belonged in the library but not much had been done about library provisions for using the data. I have a technical background so handling the data was not a problem but standards for cataloging it were. It was in this context that I heard about perl. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
Nope. The join() function is smart that way. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: NCOAUG Training Day, Aug 16 Chicago -Original Message- Adar Sent: Thursday, August 15, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hello Jared I do not know Perl but it seems to me that your script will put a comma (',') before the first value, which will add a first blank column on input. Feel free to correct me if I am wrong but do not RTFM because I do not have the manuals. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 8:53 AM > > Rachel, > > This snippet is reading data from a previously opened > handle to a table. The 'print' statement prints a quote, > the contents of the array ref $ary delimited with ",", and > closes with quote and a newline. > > Maybe not readable if you've never programmed in Perl, > but pretty simple stuff with a little experience. > > Jared > > On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > > readable. uh huh. sure > > > > how does this create a csv file? > > > > --- [EMAIL PROTECTED] wrote: > > > How many of those "non-cryptic" languages can dump a table > > > to a CSV file in 2 lines of (readable ) code? > > > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > > >} > > > > > > Come over to the dark side Chris. ;) > > > > > > Jared > > > > > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 08/14/2002 07:28 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Subject:RE: RE: Dba tools on NT > > > > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > > > I just have some issues with a language that has more special > > > characters > > > in > > > it then alpha characters. > > > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > > little > > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > > > -Original Message- > > > Sent: Tuesday, August 13, 2002 5:32 PM > > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > > > > I'll agree with Jared. Given any programming or scripting language > > > and > > > there's > > > some duhveloper out there who can make a completely obfuscated mess > > > out of > > > it. > > > I was once told that it was impossible under Ada, boy did that ever > > > get > > > retracted by the author in a hurry!! > > > > > > Dick Goulet > > > > > > Reply Separator > > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > > Date: 8/13/2002 2:06 PM > > > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > > for > > > it's "readability" and "maintainability". I'm not slamming Perl, it > > > has > > > saved my behind on W2K platforms, which has no real scripting > > > language. > > > And > > > I did advance order a copy of your book. Not that I want to be a > > > Duhveloper... > > > > > > > > > > > > -Original Message- > > > Sent: Tuesday, August 13, 2002 4:42 PM > > > To: [EMAIL PROTECTED] > > > Cc: Grabowy, Chris > > > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > > > done, > > > and > > > > > > > impossible to maintain... > > > > > > Of course, you can say this about any programming or scripting > > > language. > > > > > > It all depends on the ability of the programmer. > > > > > > Jared > > > > > > > > > > > > > > > > &g
RE: RE: Dba tools on NT
You know, I miss that 'Part-Time Perl Evangelist' tagline... :) Brian -Original Message- Sent: Thursday, August 15, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Jared Still, Oracle DBA and part-time Perl defender... 2 full-time jobs!! -Original Message- Sent: Thursday, August 15, 2002 12:53 AM To: Multiple recipients of list ORACLE-L As with any language, it's assumed that the developer will attempt to learn the language. :) This is pretty simply stuff, and very readable to folks with smattering of Perl knowledge. Jared On Wednesday 14 August 2002 20:38, Grabowy, Chris wrote: > How many developers can maintain that "cryptic" Perl code? > > Come over to the light...don't be afraid. > > Chris > > PS. 20 alpha characters...and about 25 special characters in that bit of > code.hm, not going to say anything about that. > > > -Original Message- > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > Sent: 8/14/2002 2:03 PM > > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; >} > > Come over to the dark side Chris. ;) > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
Hello Jared I do not know Perl but it seems to me that your script will put a comma (',') before the first value, which will add a first blank column on input. Feel free to correct me if I am wrong but do not RTFM because I do not have the manuals. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 8:53 AM > > Rachel, > > This snippet is reading data from a previously opened > handle to a table. The 'print' statement prints a quote, > the contents of the array ref $ary delimited with ",", and > closes with quote and a newline. > > Maybe not readable if you've never programmed in Perl, > but pretty simple stuff with a little experience. > > Jared > > On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > > readable. uh huh. sure > > > > how does this create a csv file? > > > > --- [EMAIL PROTECTED] wrote: > > > How many of those "non-cryptic" languages can dump a table > > > to a CSV file in 2 lines of (readable ) code? > > > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > > >} > > > > > > Come over to the dark side Chris. ;) > > > > > > Jared > > > > > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 08/14/2002 07:28 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Subject:RE: RE: Dba tools on NT > > > > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > > > I just have some issues with a language that has more special > > > characters > > > in > > > it then alpha characters. > > > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > > little > > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > > > -Original Message- > > > Sent: Tuesday, August 13, 2002 5:32 PM > > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > > > > I'll agree with Jared. Given any programming or scripting language > > > and > > > there's > > > some duhveloper out there who can make a completely obfuscated mess > > > out of > > > it. > > > I was once told that it was impossible under Ada, boy did that ever > > > get > > > retracted by the author in a hurry!! > > > > > > Dick Goulet > > > > > > Reply Separator > > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > > Date: 8/13/2002 2:06 PM > > > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > > for > > > it's "readability" and "maintainability". I'm not slamming Perl, it > > > has > > > saved my behind on W2K platforms, which has no real scripting > > > language. > > > And > > > I did advance order a copy of your book. Not that I want to be a > > > Duhveloper... > > > > > > > > > > > > -Original Message- > > > Sent: Tuesday, August 13, 2002 4:42 PM > > > To: [EMAIL PROTECTED] > > > Cc: Grabowy, Chris > > > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > > > done, > > > and > > > > > > > impossible to maintain... > > > > > > Of course, you can say this about any programming or scripting > > > language. > > > > > > It all depends on the ability of the programmer. > > > > > > Jared > > > > > > > > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 08/13/2002 10:24 AM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Subject:RE: Dba tools on NT > > > >
RE: RE: Dba tools on NT
Jared Still, Oracle DBA and part-time Perl defender... 2 full-time jobs!! -Original Message- Sent: Thursday, August 15, 2002 12:53 AM To: Multiple recipients of list ORACLE-L As with any language, it's assumed that the developer will attempt to learn the language. :) This is pretty simply stuff, and very readable to folks with smattering of Perl knowledge. Jared On Wednesday 14 August 2002 20:38, Grabowy, Chris wrote: > How many developers can maintain that "cryptic" Perl code? > > Come over to the light...don't be afraid. > > Chris > > PS. 20 alpha characters...and about 25 special characters in that bit of > code.hm, not going to say anything about that. > > > -Original Message- > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > Sent: 8/14/2002 2:03 PM > > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; >} > > Come over to the dark side Chris. ;) > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
(reading all the replies from others, putting my feet up) I rest my case... Does that make it two kegs of beer you owe me? -Original Message- Sent: Thursday, August 15, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ",", and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with a little experience. Jared On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > readable. uh huh. sure > > how does this create a csv file? > > --- [EMAIL PROTECTED] wrote: > > How many of those "non-cryptic" languages can dump a table > > to a CSV file in 2 lines of (readable ) code? > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > >} > > > > Come over to the dark side Chris. ;) > > > > Jared > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: RE: Dba tools on NT > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > I just have some issues with a language that has more special > > characters > > in > > it then alpha characters. > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > little > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 5:32 PM > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > I'll agree with Jared. Given any programming or scripting language > > and > > there's > > some duhveloper out there who can make a completely obfuscated mess > > out of > > it. > > I was once told that it was impossible under Ada, boy did that ever > > get > > retracted by the author in a hurry!! > > > > Dick Goulet > > > > Reply Separator > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > Date: 8/13/2002 2:06 PM > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > for > > it's "readability" and "maintainability". I'm not slamming Perl, it > > has > > saved my behind on W2K platforms, which has no real scripting > > language. > > And > > I did advance order a copy of your book. Not that I want to be a > > Duhveloper... > > > > > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 4:42 PM > > To: [EMAIL PROTECTED] > > Cc: Grabowy, Chris > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > done, > > and > > > > > impossible to maintain... > > > > Of course, you can say this about any programming or scripting > > language. > > > > It all depends on the ability of the programmer. > > > > Jared > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/13/2002 10:24 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Dba tools on NT > > > > > > And it's difficult to write, looks like scrambled eggs when your > > done, and > > impossible to maintain... > > > > On the other hand, you could write the entire Windows XP operating > > system > > in > > one line of Perl...including Internet Explorer. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 12:49 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Without a doubt - perl - get it free from www.activestate.com. Why > > use it? > > Well, it is so flexible compared to other NT/DOS scripting tools > > you'll > > wonder why you never had it before! It's also portable meaning all > > those > > scripts you w
Re[2]: RE: Dba tools on NT
One of the things I love about doing C code is your ability to create libraries and/or DLL's on NT (.so files on Unix, which I haven't mastered yet). When one of our developers asked HOW DO I DO THIS some months ago, we wrote the following code: void main(int argc, char *argv[]) { char stmt[1000]; if(!logon(argv[1], argv[2], argv[3])) { printf("Cannot connect to database %s\n", argv[3]); exit(1); } sprintf(stmt, "SELECT * FROM %s\0", argv[5]); export_to_file(argv[4], stmt); logoff(1); exit(0); } Worked like a champ. Dick Goulet Reply Separator Author: Jared Still <[EMAIL PROTECTED]> Date: 8/14/2002 10:53 PM Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ",", and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with a little experience. Jared On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > readable. uh huh. sure > > how does this create a csv file? > > --- [EMAIL PROTECTED] wrote: > > How many of those "non-cryptic" languages can dump a table > > to a CSV file in 2 lines of (readable ) code? > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > >} > > > > Come over to the dark side Chris. ;) > > > > Jared > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: RE: Dba tools on NT > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > I just have some issues with a language that has more special > > characters > > in > > it then alpha characters. > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > little > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 5:32 PM > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > I'll agree with Jared. Given any programming or scripting language > > and > > there's > > some duhveloper out there who can make a completely obfuscated mess > > out of > > it. > > I was once told that it was impossible under Ada, boy did that ever > > get > > retracted by the author in a hurry!! > > > > Dick Goulet > > > > Reply Separator > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > Date: 8/13/2002 2:06 PM > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > for > > it's "readability" and "maintainability". I'm not slamming Perl, it > > has > > saved my behind on W2K platforms, which has no real scripting > > language. > > And > > I did advance order a copy of your book. Not that I want to be a > > Duhveloper... > > > > > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 4:42 PM > > To: [EMAIL PROTECTED] > > Cc: Grabowy, Chris > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > done, > > and > > > > > impossible to maintain... > > > > Of course, you can say this about any programming or scripting > > language. > > > > It all depends on the ability of the programmer. > > > > Jared > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/13/2002 10:24 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Dba tools on NT > > > > > > And it's difficult to write, looks like scrambled eggs when your > > done, and > > impossible to maintain... > > > > On the other hand, you could write the entire Windows XP operating > > system > > in > > one line of
Re: RE: Dba tools on NT
Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ",", and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with a little experience. Jared On Wednesday 14 August 2002 18:23, Rachel Carmichael wrote: > readable. uh huh. sure > > how does this create a csv file? > > --- [EMAIL PROTECTED] wrote: > > How many of those "non-cryptic" languages can dump a table > > to a CSV file in 2 lines of (readable ) code? > > > >while ( my $ary = $sth->fetchrow_arrayref ) { > > print q{"} . join(q{","},@{$ary}) . qq{"\n}; > >} > > > > Come over to the dark side Chris. ;) > > > > Jared > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/14/2002 07:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: RE: Dba tools on NT > > > > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > > > I just have some issues with a language that has more special > > characters > > in > > it then alpha characters. > > > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > > little > > bit of BASIC...I guess that's why I enjoy PL/SQL. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 5:32 PM > > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > > > > I'll agree with Jared. Given any programming or scripting language > > and > > there's > > some duhveloper out there who can make a completely obfuscated mess > > out of > > it. > > I was once told that it was impossible under Ada, boy did that ever > > get > > retracted by the author in a hurry!! > > > > Dick Goulet > > > > Reply Separator > > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > > Date: 8/13/2002 2:06 PM > > > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > > for > > it's "readability" and "maintainability". I'm not slamming Perl, it > > has > > saved my behind on W2K platforms, which has no real scripting > > language. > > And > > I did advance order a copy of your book. Not that I want to be a > > Duhveloper... > > > > > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 4:42 PM > > To: [EMAIL PROTECTED] > > Cc: Grabowy, Chris > > > > > And it's difficult to write, looks like scrambled eggs when your > > > > done, > > and > > > > > impossible to maintain... > > > > Of course, you can say this about any programming or scripting > > language. > > > > It all depends on the ability of the programmer. > > > > Jared > > > > > > > > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 08/13/2002 10:24 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Dba tools on NT > > > > > > And it's difficult to write, looks like scrambled eggs when your > > done, and > > impossible to maintain... > > > > On the other hand, you could write the entire Windows XP operating > > system > > in > > one line of Perl...including Internet Explorer. > > > > -Original Message- > > Sent: Tuesday, August 13, 2002 12:49 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Without a doubt - perl - get it free from www.activestate.com. Why > > use it? > > Well, it is so flexible compared to other NT/DOS scripting tools > > you'll > > wonder why you never had it before! It's also portable meaning all > > those > > scripts you write should work on multi platforms with just a little > > tweak! > > > > Lewis Bishop > > --- > > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultan
Re: RE: Dba tools on NT
As with any language, it's assumed that the developer will attempt to learn the language. :) This is pretty simply stuff, and very readable to folks with smattering of Perl knowledge. Jared On Wednesday 14 August 2002 20:38, Grabowy, Chris wrote: > How many developers can maintain that "cryptic" Perl code? > > Come over to the light...don't be afraid. > > Chris > > PS. 20 alpha characters...and about 25 special characters in that bit of > code.hm, not going to say anything about that. > > > -Original Message- > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > Sent: 8/14/2002 2:03 PM > > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; >} > > Come over to the dark side Chris. ;) > > Jared > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/14/2002 07:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: RE: Dba tools on NT > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > I just have some issues with a language that has more special characters > > in > it then alpha characters. > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > little > bit of BASIC...I guess that's why I enjoy PL/SQL. > > -Original Message- > Sent: Tuesday, August 13, 2002 5:32 PM > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > I'll agree with Jared. Given any programming or scripting language and > there's > some duhveloper out there who can make a completely obfuscated mess out > of > it. > I was once told that it was impossible under Ada, boy did that ever get > retracted by the author in a hurry!! > > Dick Goulet > > Reply Separator > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > Date: 8/13/2002 2:06 PM > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > for > it's "readability" and "maintainability". I'm not slamming Perl, it has > saved my behind on W2K platforms, which has no real scripting language. > And > I did advance order a copy of your book. Not that I want to be a > Duhveloper... > > > > -Original Message- > Sent: Tuesday, August 13, 2002 4:42 PM > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > > > And it's difficult to write, looks like scrambled eggs when your done, > > and > > > impossible to maintain... > > Of course, you can say this about any programming or scripting language. > > It all depends on the ability of the programmer. > > Jared > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/13/2002 10:24 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Dba tools on NT > > > And it's difficult to write, looks like scrambled eggs when your done, > and > impossible to maintain... > > On the other hand, you could write the entire Windows XP operating > system > in > one line of Perl...including Internet Explorer. > > -Original Message- > Sent: Tuesday, August 13, 2002 12:49 PM > To: Multiple recipients of list ORACLE-L > > > Without a doubt - perl - get it free from www.activestate.com. Why use > it? > Well, it is so flexible compared to other NT/DOS scripting tools you'll > wonder why you never had it before! It's also portable meaning all those > scripts you write should work on multi platforms with just a little > tweak! > > Lewis Bishop > --- > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant > Phone - 020 8298 3418 > Mobile - 07950 380857 > Email - [EMAIL PROTECTED] > > > -Original Message- > Sent: 13 August 2002 17:25 > To: Multiple recipients of list ORACLE-L > > This header confirms that this email message has been swept for the > presence of computer viruses. > > Corporate IT > THE WOOLWICH > -- > > Hello all > > We are looking on programming and scripting tools > for DBA team on NT. > > Can you, oracle DBA's on NT, tell me off the list
RE: RE: Dba tools on NT
Title: RE: RE: Dba tools on NT Stay on the good side Jared. Your code snippet looks great to me, and looking at it finally showed me a clear example of how that q{} thingy works. I write a lot of Oracle utility type stuff that has to run on both Windows and UNIX. Perl does the job every time. Rachel, Jared should admit that he would probably need just a few more characters (about 6 alpha and 48 special!) to actually run the code, but the essence is there and with a glance you can tell that it does produce CSV output using DBI/DBD to access the database. :) Dan. "There are only 10 types of people in the world: Those who understand binary, and those who don't." -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 8:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Dba tools on NT How many developers can maintain that "cryptic" Perl code? Come over to the light...don't be afraid. Chris PS. 20 alpha characters...and about 25 special characters in that bit of code.hm, not going to say anything about that. -Original Message- To: [EMAIL PROTECTED] Cc: Grabowy, Chris Sent: 8/14/2002 2:03 PM How many of those "non-cryptic" languages can dump a table to a CSV file in 2 lines of (readable ) code? while ( my $ary = $sth->fetchrow_arrayref ) { print q{"} . join(q{","},@{$ary}) . qq{"\n}; } Come over to the dark side Chris. ;) Jared
RE: RE: Dba tools on NT
How many developers can maintain that "cryptic" Perl code? Come over to the light...don't be afraid. Chris PS. 20 alpha characters...and about 25 special characters in that bit of code.hm, not going to say anything about that. -Original Message- To: [EMAIL PROTECTED] Cc: Grabowy, Chris Sent: 8/14/2002 2:03 PM How many of those "non-cryptic" languages can dump a table to a CSV file in 2 lines of (readable ) code? while ( my $ary = $sth->fetchrow_arrayref ) { print q{"} . join(q{","},@{$ary}) . qq{"\n}; } Come over to the dark side Chris. ;) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/14/2002 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Dba tools on NT Spaghetti code is easy to write...just throw some GOTOs in there. I just have some issues with a language that has more special characters in it then alpha characters. Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a little bit of BASIC...I guess that's why I enjoy PL/SQL. -Original Message- Sent: Tuesday, August 13, 2002 5:32 PM To: Grabowy, Chris; Multiple recipients of list ORACLE-L I'll agree with Jared. Given any programming or scripting language and there's some duhveloper out there who can make a completely obfuscated mess out of it. I was once told that it was impossible under Ada, boy did that ever get retracted by the author in a hurry!! Dick Goulet Reply Separator Author: "Grabowy; Chris" <[EMAIL PROTECTED]> Date: 8/13/2002 2:06 PM DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended s
RE: RE: Dba tools on NT
readable. uh huh. sure how does this create a csv file? --- [EMAIL PROTECTED] wrote: > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; >} > > Come over to the dark side Chris. ;) > > Jared > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/14/2002 07:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: RE: Dba tools on NT > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > I just have some issues with a language that has more special > characters > in > it then alpha characters. > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > little > bit of BASIC...I guess that's why I enjoy PL/SQL. > > -Original Message- > Sent: Tuesday, August 13, 2002 5:32 PM > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > I'll agree with Jared. Given any programming or scripting language > and > there's > some duhveloper out there who can make a completely obfuscated mess > out of > it. > I was once told that it was impossible under Ada, boy did that ever > get > retracted by the author in a hurry!! > > Dick Goulet > > Reply Separator > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > Date: 8/13/2002 2:06 PM > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > for > it's "readability" and "maintainability". I'm not slamming Perl, it > has > saved my behind on W2K platforms, which has no real scripting > language. > And > I did advance order a copy of your book. Not that I want to be a > Duhveloper... > > > > -Original Message- > Sent: Tuesday, August 13, 2002 4:42 PM > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > > > > And it's difficult to write, looks like scrambled eggs when your > done, > and > > impossible to maintain... > > Of course, you can say this about any programming or scripting > language. > > It all depends on the ability of the programmer. > > Jared > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/13/2002 10:24 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Dba tools on NT > > > And it's difficult to write, looks like scrambled eggs when your > done, and > impossible to maintain... > > On the other hand, you could write the entire Windows XP operating > system > in > one line of Perl...including Internet Explorer. > > -Original Message- > Sent: Tuesday, August 13, 2002 12:49 PM > To: Multiple recipients of list ORACLE-L > > > Without a doubt - perl - get it free from www.activestate.com. Why > use it? > Well, it is so flexible compared to other NT/DOS scripting tools > you'll > wonder why you never had it before! It's also portable meaning all > those > scripts you write should work on multi platforms with just a little > tweak! > > Lewis Bishop > --- > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant > Phone - 020 8298 3418 > Mobile - 07950 380857 > Email - [EMAIL PROTECTED] > > > -Original Message- > Sent: 13 August 2002 17:25 > To: Multiple recipients of list ORACLE-L > > This header confirms that this email message has been swept for the > presence of computer viruses. > > Corporate IT > THE WOOLWICH > -- > > Hello all > > We are looking on programming and scripting tools > for DBA team on NT. > > Can you, oracle DBA's on NT, tell me off the list > what tools you are using for these functions > and, if you be so kind, why you choose them. > > TIA > > Yechiel Adar > Mehish > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > --
RE: Dba tools on NT
I won't comment on the Perl side of things but will give some alternatives (& reasons). Does the DBA team or system admins already know any Windows scripting tools - if so I would consider using them? What are you trying to script - this will affect which tool is appropriate? Are you going to be using OEM? Perhaps more important than the scripting language what are you going to use as a scheduler - AT, Scheduling service, OEM or some other product? As for scripting tools: NT's CMD / batch language - you can do lots of things in it - but many are obscure to achieve. It has the advantage of being free but more importantly it is on every machine and you don't need approval to install it. What about VBScript, Kixx or WSH - your Windows admins may be using some of these already. Also, if trying to script a GUI application, consider Microsoft's scripit tool that lets you input into windows. If you want some links on batch / CMD programming then ask. We use OEM events to monitor, OEMs scheduler, OEM to automate RMAN backups & exports. A few utilities from Windows resource kits and some batch files (eg restart listener log, monitor listener log size, delete old files and so on) HTH, Bruce Reardon -Original Message- Sent: Thursday, 15 August 2002 11:23 readable. uh huh. sure how does this create a csv file? --- [EMAIL PROTECTED] wrote: > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; >} > > Come over to the dark side Chris. ;) > > Jared > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/14/2002 07:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: RE: Dba tools on NT > > > Spaghetti code is easy to write...just throw some GOTOs in there. > > I just have some issues with a language that has more special > characters > in > it then alpha characters. > > Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a > little > bit of BASIC...I guess that's why I enjoy PL/SQL. > > -Original Message- > Sent: Tuesday, August 13, 2002 5:32 PM > To: Grabowy, Chris; Multiple recipients of list ORACLE-L > > > I'll agree with Jared. Given any programming or scripting language > and > there's > some duhveloper out there who can make a completely obfuscated mess > out of > it. > I was once told that it was impossible under Ada, boy did that ever > get > retracted by the author in a hurry!! > > Dick Goulet > > Reply Separator > Author: "Grabowy; Chris" <[EMAIL PROTECTED]> > Date: 8/13/2002 2:06 PM > > DOH Ouch...(limping along)...come on now. Perl has won "awards" > for > it's "readability" and "maintainability". I'm not slamming Perl, it > has > saved my behind on W2K platforms, which has no real scripting > language. > And > I did advance order a copy of your book. Not that I want to be a > Duhveloper... > > > > -Original Message- > Sent: Tuesday, August 13, 2002 4:42 PM > To: [EMAIL PROTECTED] > Cc: Grabowy, Chris > > > > And it's difficult to write, looks like scrambled eggs when your > done, > and > > impossible to maintain... > > Of course, you can say this about any programming or scripting > language. > > It all depends on the ability of the programmer. > > Jared > > > > > > > "Grabowy, Chris" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/13/2002 10:24 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Dba tools on NT > > > And it's difficult to write, looks like scrambled eggs when your > done, and > impossible to maintain... > > On the other hand, you could write the entire Windows XP operating > system > in > one line of Perl...including Internet Explorer. > > -Original Message- > Sent: Tuesday, August 13, 2002 12:49 PM > To: Multiple recipients of list ORACLE-L > > > Without a doubt - perl - get it free from www.activestate.com. Why > use it? > Well, it is so flexible compared to other NT/DOS scripting tools > you&
RE: RE: Dba tools on NT
Looks OK to me, seems about right Although when you start using Macros and such the readability drops a little as it can take a bit of jumping around to understand it. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Jacques Kilchoer <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 15-08-2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject: RE: RE: Dba tools on NT > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > >while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; "Readable" code? Now take COBOL, that was readable code! e.g. (from memory - excuse any errors) IDENTIFICATION DIVISION. PROGRAM-ID. DUMP_VALUES. AUTHOR. MOI. ENVIRONMENT DIVISION. INPUT-OUTPUT SECTION. FILE-CONTROL. SELECT MYDATAFILE ASSIGN TO "SOMEFILE.DAT" ORGANIZATION IS LINE SEQUENTIAL. DATA DIVISION. FILE SECTION. FD MYDATAFILE. 01 MYCOLS. 05 ID PIC 9(7). 05 NAME. 10 FIRST_NAME PIC X(20). 10 LAST_NAMEPIC X(20). PROCEDURE DIVISION. BEGIN. OPEN INPUT MYDATAFILE. READ MYDATAFILE AT END MOVE HIGH-VALUES TO MYCOLS END-READ. PERFORM UNTIL MYCOLS = HIGH-VALUES DISPLAY ID SPACE FIRSTNAME SPACE LASTNAME END-DISPLAY READ MYDATAFILE AT END MOVE HIGH-VALUES TO MYCOLS END-READ END-PERFORM. CLOSE MYDATAFILE. STOP RUN. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
Title: RE: RE: Dba tools on NT > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > How many of those "non-cryptic" languages can dump a table > to a CSV file in 2 lines of (readable ) code? > > while ( my $ary = $sth->fetchrow_arrayref ) { > print q{"} . join(q{","},@{$ary}) . qq{"\n}; "Readable" code? Now take COBOL, that was readable code! e.g. (from memory - excuse any errors) IDENTIFICATION DIVISION. PROGRAM-ID. DUMP_VALUES. AUTHOR. MOI. ENVIRONMENT DIVISION. INPUT-OUTPUT SECTION. FILE-CONTROL. SELECT MYDATAFILE ASSIGN TO "SOMEFILE.DAT" ORGANIZATION IS LINE SEQUENTIAL. DATA DIVISION. FILE SECTION. FD MYDATAFILE. 01 MYCOLS. 05 ID PIC 9(7). 05 NAME. 10 FIRST_NAME PIC X(20). 10 LAST_NAME PIC X(20). PROCEDURE DIVISION. BEGIN. OPEN INPUT MYDATAFILE. READ MYDATAFILE AT END MOVE HIGH-VALUES TO MYCOLS END-READ. PERFORM UNTIL MYCOLS = HIGH-VALUES DISPLAY ID SPACE FIRSTNAME SPACE LASTNAME END-DISPLAY READ MYDATAFILE AT END MOVE HIGH-VALUES TO MYCOLS END-READ END-PERFORM. CLOSE MYDATAFILE. STOP RUN.
RE: RE: Dba tools on NT
How many of those "non-cryptic" languages can dump a table to a CSV file in 2 lines of (readable ) code? while ( my $ary = $sth->fetchrow_arrayref ) { print q{"} . join(q{","},@{$ary}) . qq{"\n}; } Come over to the dark side Chris. ;) Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/14/2002 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Dba tools on NT Spaghetti code is easy to write...just throw some GOTOs in there. I just have some issues with a language that has more special characters in it then alpha characters. Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a little bit of BASIC...I guess that's why I enjoy PL/SQL. -Original Message- Sent: Tuesday, August 13, 2002 5:32 PM To: Grabowy, Chris; Multiple recipients of list ORACLE-L I'll agree with Jared. Given any programming or scripting language and there's some duhveloper out there who can make a completely obfuscated mess out of it. I was once told that it was impossible under Ada, boy did that ever get retracted by the author in a hurry!! Dick Goulet Reply Separator Author: "Grabowy; Chris" <[EMAIL PROTECTED]> Date: 8/13/2002 2:06 PM DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you h
RE: Dba tools on NT
To know Python is to love Python and eschew Perl... obfuscation is possible albeit more difficult. ;-) -Original Message- Sent: Wednesday, August 14, 2002 1:27 PM To: Multiple recipients of list ORACLE-L Importance: High Well, there is the obfuscated Perl contest, but that's intentional. :) If you make use of 'use English;', the two character system variables can be replaced with readable names, though it involves a lot more typing. I don't see how it's any less readable than C. I really don't know how to compare it's readability issues to other scripting languages, ( Python, Ruby, etc.) cuz I don't know how to use them. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 03:06 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Ok, ok!!! I give up. Perl is the greatest language in the world!!! We should all learn to speak it!!! Happy?? -Original Message- Sent: Wednesday, August 14, 2002 2:15 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris Well, there is the obfuscated Perl contest, but that's intentional. :) If you make use of 'use English;', the two character system variables can be replaced with readable names, though it involves a lot more typing. I don't see how it's any less readable than C. I really don't know how to compare it's readability issues to other scripting languages, ( Python, Ruby, etc.) cuz I don't know how to use them. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 03:06 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acc
RE: Dba tools on NT
Well, there is the obfuscated Perl contest, but that's intentional. :) If you make use of 'use English;', the two character system variables can be replaced with readable names, though it involves a lot more typing. I don't see how it's any less readable than C. I really don't know how to compare it's readability issues to other scripting languages, ( Python, Ruby, etc.) cuz I don't know how to use them. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 03:06 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in t
RE: RE: Dba tools on NT
I'll endorse 100% those comments on UltraEdit peter edinburgh > > > The editor of choice for me is Ultraedit (www.idmcomp.com) > At $25 per copy/seat > it's damned good. Syntax highlighting for C, HTML, and > several others included > plus you can customize it very easily. Mine's set up for > Pro*C, SQL, PL/SQL, > and SQR (via PeopleSoft). Also allows one to edit Unix files > via FTP. Been > using it for three years now & I still haven't learned all of > it's capabilities. > Sweet!! > > Dick Goulet > > Reply Separator > Author: Jacques Kilchoer <[EMAIL PROTECTED]> > Date: 8/13/2002 4:08 PM > > > -Original Message- > > [EMAIL PROTECTED] > > > > Scripting: Perl, because it can do anything you ask of it. > > Editor: Vim - www.vim.org - same reason > > Actually I like this little text editor: > http://www.fixedsys.com/context/ > One of its advantages is its syntax highlighting. And it's free! > > > > > > > RE: Dba tools on NT > > > > > -Original Message- > > [EMAIL PROTECTED] > > > > Scripting: Perl, because it can do > anything you ask of > it. > > Editor: Vim - www.vim.org - same > reason > > > Actually I like this little text editor: > http://www.fixedsys.com/context/"; > TARGET="_blank">http://www.fixedsys.com/context/ > One of its advantages is its syntax > highlighting. And it's > free! > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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, 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.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
I've liked and used PFE or Programmer's File Editor for a long time now. http://www.lancs.ac.uk/people/cpaap/pfe/ I have pulled in, read and edited "empty" export files up to many MB in size, and have used it to read in entire directories of files to clean up, inspect, and the like. I have done files upwards of 180mb and while it takes a bit of time, it manages them. It doesn't often choke on exe files, or "unknown" files, though sometimes you'll get the "lines truncated"... But on those kinds of things, I'm just trying to determine what the heck the file is. Often the character strings will give clues to what they might be. I can set up the thing to use courier-6 or so, and read 150 column reports on the screen without having to scroll, set the screen up dark blue with yellow characters, and it's not bad on the eyes. It's got that "\n" for return, etc... Hey, it works. I've played with vim and textpad, but never took them as much. Maks ThinkSpark Richmond, VA 804-744-1545 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ron Thomas > Sent: Tuesday, August 13, 2002 9:18 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Dba tools on NT > > > > >Actually I like this little text editor: > >http://www.fixedsys.com/context/ > >One of its advantages is its syntax highlighting. And it's free! > Disadvantage is it's windows only... > > Ron Thomas > Hypercom, Inc > [EMAIL PROTECTED] > If A = B and B = C, then A = C, except where void or prohibited > by law. -- Roy Santoro > > > > > [EMAIL PROTECTED] > >To: > [EMAIL PROTECTED] > > 08/13/02 05:08 PMcc: > > Please respond toSubject: RE: Dba > tools on NT > ORACLE-L > > > > > > > > > > > -Original Message- > > [EMAIL PROTECTED] > > > > Scripting: Perl, because it can do anything you ask of it. > > Editor: Vim - www.vim.org - same reason > > > Actually I like this little text editor: > http://www.fixedsys.com/context/ > One of its advantages is its syntax highlighting. And it's free! > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Thomas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
I go for emacs (www.gnu.org). I've got it running in viper-mode to keep my vi fingers working; its got syntax-highlighting for just about everything (if you can find an up to date mode for it); the JDE IDE for java development; ftp editing; two windows running on a twin-head machine so I can switch between buffers in either; and if you fancy it you can run a shell (or sqlplus), read mail or news in it. It will run on most operating systems and is absolutely free. David Lord > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 14 August 2002 14:48 > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: Dba tools on NT > > > The editor of choice for me is Ultraedit (www.idmcomp.com) > At $25 per copy/seat > it's damned good. Syntax highlighting for C, HTML, and > several others included > plus you can customize it very easily. Mine's set up for > Pro*C, SQL, PL/SQL, > and SQR (via PeopleSoft). Also allows one to edit Unix files > via FTP. Been > using it for three years now & I still haven't learned all of > it's capabilities. > Sweet!! > > Dick Goulet > > Reply Separator > Author: Jacques Kilchoer <[EMAIL PROTECTED]> > Date: 8/13/2002 4:08 PM > > > -Original Message- > > [EMAIL PROTECTED] > > > > Scripting: Perl, because it can do anything you ask of it. > > Editor: Vim - www.vim.org - same reason > > Actually I like this little text editor: > http://www.fixedsys.com/context/ > One of its advantages is its syntax highlighting. And it's free! > > > > > > > RE: Dba tools on NT > > > > > -Original Message- > > [EMAIL PROTECTED] > > > > Scripting: Perl, because it can do > anything you ask of > it. > > Editor: Vim - www.vim.org - same > reason > > > Actually I like this little text editor: > http://www.fixedsys.com/context/"; > TARGET="_blank">http://www.fixedsys.com/context/ > One of its advantages is its syntax > highlighting. And it's > free! > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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 message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Dba tools on NT
Spaghetti code is easy to write...just throw some GOTOs in there. I just have some issues with a language that has more special characters in it then alpha characters. Sigh. I miss the good ole days, COBOL, Fortran, Pascal, and even a little bit of BASIC...I guess that's why I enjoy PL/SQL. -Original Message- Sent: Tuesday, August 13, 2002 5:32 PM To: Grabowy, Chris; Multiple recipients of list ORACLE-L I'll agree with Jared. Given any programming or scripting language and there's some duhveloper out there who can make a completely obfuscated mess out of it. I was once told that it was impossible under Ada, boy did that ever get retracted by the author in a hurry!! Dick Goulet Reply Separator Author: "Grabowy; Chris" <[EMAIL PROTECTED]> Date: 8/13/2002 2:06 PM DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV
RE: RE: Dba tools on NT
Dick, you said the magic word! :D Only these were done on purpose... http://www.samag.com/tpj/obfuscated/ Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 5:34 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: Dba tools on NT > > > I'll agree with Jared. Given any programming or scripting > language and there's > some duhveloper out there who can make a completely > obfuscated mess out of it. > I was once told that it was impossible under Ada, boy did > that ever get > retracted by the author in a hurry!! > > Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Or Nedit from http://www.nedit.org. I've even customized syntax highlighting for 8i init.ora files! Of course to run under Windohs, you'll need CygWin and and X Server. I wonder why? ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Ron Thomas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 8:18 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Dba tools on NT > > > > >Actually I like this little text editor: > >http://www.fixedsys.com/context/ > >One of its advantages is its syntax highlighting. And it's free! > Disadvantage is it's windows only... > > Ron Thomas > Hypercom, Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Title: RE: Dba tools on NT But... but... in my defense, can I point to the subject line of the request? "on NT" > -Original Message- > From: Ron Thomas [mailto:[EMAIL PROTECTED]] > > >Actually I like this little text editor: > >http://www.fixedsys.com/context/ > >One of its advantages is its syntax highlighting. And it's free! > Disadvantage is it's windows only...
RE: Dba tools on NT
Title: RE: Dba tools on NT Mr. Gupta is very wise. The Quest set of tools is the best. > -Original Message- > From: Manavendra Gupta [mailto:[EMAIL PROTECTED]] > > Quest software (www.quest.com) provides a nice array of tools.
RE: Dba tools on NT
>Actually I like this little text editor: >http://www.fixedsys.com/context/ >One of its advantages is its syntax highlighting. And it's free! Disadvantage is it's windows only... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/13/02 05:08 PMcc: Please respond to Subject: RE: Dba tools on NT ORACLE-L > -Original Message- > [EMAIL PROTECTED] > > Scripting: Perl, because it can do anything you ask of it. > Editor: Vim - www.vim.org - same reason Actually I like this little text editor: http://www.fixedsys.com/context/ One of its advantages is its syntax highlighting. And it's free! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Title: RE: Dba tools on NT > -Original Message- > [EMAIL PROTECTED] > > Scripting: Perl, because it can do anything you ask of it. > Editor: Vim - www.vim.org - same reason Actually I like this little text editor: http://www.fixedsys.com/context/ One of its advantages is its syntax highlighting. And it's free!
RE: Dba tools on NT
DOH Ouch...(limping along)...come on now. Perl has won "awards" for it's "readability" and "maintainability". I'm not slamming Perl, it has saved my behind on W2K platforms, which has no real scripting language. And I did advance order a copy of your book. Not that I want to be a Duhveloper... -Original Message- Sent: Tuesday, August 13, 2002 4:42 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris > And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 nam
RE: Dba tools on NT
> And it's difficult to write, looks like scrambled eggs when your done, and > impossible to maintain... Of course, you can say this about any programming or scripting language. It all depends on the ability of the programmer. Jared "Grabowy, Chris" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Dba tools on NT And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourse
RE: Dba tools on NT
Amen. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: NCOAUG Training Day, Aug 16 Chicago -Original Message- [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Scripting: Perl, because it can do anything you ask of it. Editor: Vim - www.vim.org - same reason Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 09:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Dba tools on NT Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
OEM jobs will also work for you, if you're comfortable with Tcl. I use OEM jobs to run rman, to run exports to monitor alter logs to schedule and run some sqlplus copy scripts to schedule some data-loading and pl/sql routines to run orakill if needed ... I usually have no local access to any of the servers so its the only way I ever get anything done. "Grabowy, Chris" <[EMAIL PROTECTED]>@fatcity.com on 08/13/2002 01:24:35 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
Re: Dba tools on NT
Scripting: Perl, because it can do anything you ask of it. Editor: Vim - www.vim.org - same reason Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/13/2002 09:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Dba tools on NT Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Dan, You said: "The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus." You are correct sir! However, you can generate the sql scripts within the NT script and use the environmental within that process. For example: Within an NT script, I say: echo spool $SCRIPT_LOG/some_script_file.log > run.sql echo select * from sysdate; >> run.sql echo exit >> run.sql sqlplus user/pw @run.sql The above would interpret the $SCRIPT_LOG environmental correctly. I do the above all the time and it works just fine. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 13, 2002 1:19 PM To: Multiple recipients of list ORACLE-L I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS Toolkit for features and it runs as the user you are logged in as (i.e. oracle). Cygwin is free, but it's processes run as the adminstrator. That being said, it could be I did not configure it properly.. The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus. Instead of using these variables, I used SQL*Plus native variables populated with a login.sql script. Not a problem. I'm not certain if the same restriction is present in perl, but it is something to keep in mind. Dan Fink -Original Message- Sent: Tuesday, August 13, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS Toolkit for features and it runs as the user you are logged in as (i.e. oracle). Cygwin is free, but it's processes run as the adminstrator. That being said, it could be I did not configure it properly.. The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus. Instead of using these variables, I used SQL*Plus native variables populated with a login.sql script. Not a problem. I'm not certain if the same restriction is present in perl, but it is something to keep in mind. Dan Fink -Original Message- Sent: Tuesday, August 13, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
And it's difficult to write, looks like scrambled eggs when your done, and impossible to maintain... On the other hand, you could write the entire Windows XP operating system in one line of Perl...including Internet Explorer. -Original Message- Sent: Tuesday, August 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Quest software (www.quest.com) provides a nice array of tools. With Warm Regards, Manav. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 9:24 AM > Hello all > > We are looking on programming and scripting tools > for DBA team on NT. > > Can you, oracle DBA's on NT, tell me off the list > what tools you are using for these functions > and, if you be so kind, why you choose them. > > TIA > > Yechiel Adar > Mehish > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Yechiel, I use NT scripting (DOS) and Perl. I use these because: 1) They are free. 2). They are easily transportable from box to box - when I develop and NT script, I write it in such a way that it can easily be converted to Kshell on unix. 3). They are free 4). They are free 5). They are free Did I say they are free? - no hassle with support or licenses for different servers. I can freely give them away to whomever I want, and are easy to support. Just my opinion. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 13, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Dba tools on NT
Without a doubt - perl - get it free from www.activestate.com. Why use it? Well, it is so flexible compared to other NT/DOS scripting tools you'll wonder why you never had it before! It's also portable meaning all those scripts you write should work on multi platforms with just a little tweak! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 13 August 2002 17:25 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).