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----- > > 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 > > === message truncated === > > > __________________________________________________ > 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: Jared Still 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 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).