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 > > > > > > > > > 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: 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).