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?
>
> --- Jared.Still_at_radisys.com 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" <cgrabowy_at_fcg.com>
> > Sent by: root_at_fatcity.com
> > 08/14/2002 07:28 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > 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" <cgrabowy_at_fcg.com>
> > 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: ORACLE-L_at_fatcity.com
> > 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" <cgrabowy_at_fcg.com>
> > Sent by: root_at_fatcity.com
> > 08/13/2002 10:24 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > 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 - lewis.bishop_at_woolwich.co.uk
> >
> >
> > -----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: adar76_at_inter.net.il
> >
> > 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: ListGuru_at_fatcity.com (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 ADMINISTRATOR_at_WOOLWICH.CO.UK
> >
> > 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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).